Debian Codegraph @

www/c3ref/changes.html

raw
1 <!DOCTYPE html>
2 <html><head>
3 <meta name="viewport" content="width=device-width, initial-scale=1.0">
4 <meta http-equiv="content-type" content="text/html; charset=UTF-8">
5 <link href="../sqlite.css" rel="stylesheet">
6 <title>Count The Number Of Rows Modified</title>
7 <!-- path=../ -->
8 </head>
9 <body>
10 <div class=nosearch>
11 <a href="../index.html">
12 <img class="logo" src="../images/sqlite370_banner.svg" alt="SQLite" border="0">
13 </a>
14 <div><!-- IE hack to prevent disappearing logo --></div>
15 <div class="tagline desktoponly">
16 Small. Fast. Reliable.<br>Choose any three.
17 </div>
18 <div class="menu mainmenu">
19 <ul>
20 <li><a href="../index.html">Home</a>
21 <li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a>
22 <li class='wideonly'><a href='../about.html'>About</a>
23 <li class='desktoponly'><a href="../docs.html">Documentation</a>
24 <li class='desktoponly'><a href="../download.html">Download</a>
25 <li class='wideonly'><a href='../copyright.html'>License</a>
26 <li class='desktoponly'><a href="../support.html">Support</a>
27 <li class='desktoponly'><a href="../prosupport.html">Purchase</a>
28 <li class='search' id='search_menubutton'>
29 <a href="javascript:void(0)" onclick='toggle_search()'>Search</a>
30 </ul>
31 </div>
32 <div class="menu submenu" id="submenu">
33 <ul>
34 <li><a href='../about.html'>About</a>
35 <li><a href='../docs.html'>Documentation</a>
36 <li><a href='../download.html'>Download</a>
37 <li><a href='../support.html'>Support</a>
38 <li><a href='../prosupport.html'>Purchase</a>
39 </ul>
40 </div>
41 <div class="searchmenu" id="searchmenu">
42 <form method="GET" action="../search">
43 <select name="s" id="searchtype">
44 <option value="d">Search Documentation</option>
45 <option value="c">Search Changelog</option>
46 </select>
47 <input type="text" name="q" id="searchbox" value="">
48 <input type="submit" value="Go">
49 </form>
50 </div>
51 </div>
52 <script>
53 function toggle_div(nm) {
54 var w = document.getElementById(nm);
55 if( w.style.display=="block" ){
56 w.style.display = "none";
57 }else{
58 w.style.display = "block";
59 }
60 }
61 function toggle_search() {
62 var w = document.getElementById("searchmenu");
63 if( w.style.display=="block" ){
64 w.style.display = "none";
65 } else {
66 w.style.display = "block";
67 setTimeout(function(){
68 document.getElementById("searchbox").focus()
69 }, 30);
70 }
71 }
72 function div_off(nm){document.getElementById(nm).style.display="none";}
73 window.onbeforeunload = function(e){div_off("submenu");}
74 /* Disable the Search feature if we are not operating from CGI, since */
75 /* Search is accomplished using CGI and will not work without it. */
76 if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){
77 document.getElementById("search_menubutton").style.display = "none";
78 }
79 /* Used by the Hide/Show button beside syntax diagrams, to toggle the */
80 function hideorshow(btn,obj){
81 var x = document.getElementById(obj);
82 var b = document.getElementById(btn);
83 if( x.style.display!='none' ){
84 x.style.display = 'none';
85 b.innerHTML='show';
86 }else{
87 x.style.display = '';
88 b.innerHTML='hide';
89 }
90 return false;
91 }
92 var antiRobot = 0;
93 function antiRobotGo(){
94 if( antiRobot!=3 ) return;
95 antiRobot = 7;
96 var j = document.getElementById("mtimelink");
97 if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href");
98 }
99 function antiRobotDefense(){
100 document.body.onmousedown=function(){
101 antiRobot |= 2;
102 antiRobotGo();
103 document.body.onmousedown=null;
104 }
105 document.body.onmousemove=function(){
106 antiRobot |= 2;
107 antiRobotGo();
108 document.body.onmousemove=null;
109 }
110 setTimeout(function(){
111 antiRobot |= 1;
112 antiRobotGo();
113 }, 100)
114 antiRobotGo();
115 }
116 antiRobotDefense();
117 </script>
118 <!-- keywords: sqlite3_changes sqlite3_changes64 -->
119 <div class=nosearch>
120 <a href="../c3ref/intro.html"><h2>SQLite C Interface</h2></a>
121 <h2>Count The Number Of Rows Modified</h2>
122 </div>
123 <blockquote><pre>
124 int sqlite3_changes(sqlite3*);
125 sqlite3_int64 sqlite3_changes64(sqlite3*);
126 </pre></blockquote>
127 <p>
128 These functions return the number of rows modified, inserted or
129 deleted by the most recently completed INSERT, UPDATE or DELETE
130 statement on the database connection specified by the only parameter.
131 The two functions are identical except for the type of the return value
132 and that if the number of rows modified by the most recent INSERT, UPDATE,
133 or DELETE is greater than the maximum value supported by type "int", then
134 the return value of sqlite3_changes() is undefined. Executing any other
135 type of SQL statement does not modify the value returned by these functions.
136 For the purposes of this interface, a CREATE TABLE AS SELECT statement
137 does not count as an INSERT, UPDATE or DELETE statement and hence the rows
138 added to the new table by the CREATE TABLE AS SELECT statement are not
139 counted.</p>
140
141 <p>Only changes made directly by the INSERT, UPDATE or DELETE statement are
142 considered - auxiliary changes caused by <a href="../lang_createtrigger.html">triggers</a>,
143 <a href="../foreignkeys.html#fk_actions">foreign key actions</a> or <a href="../lang_replace.html">REPLACE</a> constraint resolution are not counted.</p>
144
145 <p>Changes to a view that are intercepted by
146 <a href="../lang_createtrigger.html#instead_of_trigger">INSTEAD OF triggers</a> are not counted. The value
147 returned by sqlite3_changes() immediately after an INSERT, UPDATE or
148 DELETE statement run on a view is always zero. Only changes made to real
149 tables are counted.</p>
150
151 <p>Things are more complicated if the sqlite3_changes() function is
152 executed while a trigger program is running. This may happen if the
153 program uses the <a href="../lang_corefunc.html#changes">changes() SQL function</a>, or if some other callback
154 function invokes sqlite3_changes() directly. Essentially:</p>
155
156 <p><ul>
157 <li> Before entering a trigger program the value returned by
158 sqlite3_changes() function is saved. After the trigger program
159 has finished, the original value is restored.</p>
160
161 <p><li> Within a trigger program each INSERT, UPDATE and DELETE
162 statement sets the value returned by sqlite3_changes()
163 upon completion as normal. Of course, this value will not include
164 any changes performed by sub-triggers, as the sqlite3_changes()
165 value will be saved and restored after each sub-trigger has run.
166 </ul></p>
167
168 <p>This means that if the changes() SQL function (or similar) is used
169 by the first INSERT, UPDATE or DELETE statement within a trigger, it
170 returns the value as set when the calling statement began executing.
171 If it is used by the second or subsequent such statement within a trigger
172 program, the value returned reflects the number of rows modified by the
173 previous INSERT, UPDATE or DELETE statement within the same trigger.</p>
174
175 <p>If a separate thread makes changes on the same database connection
176 while <a href="../c3ref/changes.html">sqlite3_changes()</a> is running then the value returned
177 is unpredictable and not meaningful.</p>
178
179 <p>See also:
180 <ul>
181 <li> the <a href="../c3ref/total_changes.html">sqlite3_total_changes()</a> interface
182 <li> the <a href="../pragma.html#pragma_count_changes">count_changes pragma</a>
183 <li> the <a href="../lang_corefunc.html#changes">changes() SQL function</a>
184 <li> the <a href="../pragma.html#pragma_data_version">data_version pragma</a>
185 </ul>
186 </p><p>See also lists of
187 <a href="../c3ref/objlist.html">Objects</a>,
188 <a href="../c3ref/constlist.html">Constants</a>, and
189 <a href="../c3ref/funclist.html">Functions</a>.</p>
190