reqmatrix.html

sqlite的帮助文档

C. <p>Parents: <a href="sysreq.html#S30100">S30100</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12014</td><td valign="top">A call to <a href="c3ref/close.html">sqlite3_close(C)</a> on a <a href="c3ref/sqlite3.html">database connection</a> C that
has one or more open <a href="c3ref/stmt.html">prepared statements</a> shall fail with
an <a href="c3ref/c_abort.html">SQLITE_BUSY</a> error code. <p>Parents: <a href="sysreq.html#S30100">S30100</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12015</td><td valign="top">A call to <a href="c3ref/close.html">sqlite3_close(C)</a> where C is a NULL pointer shall
be a harmless no-op returning SQLITE_OK. <p>Parents: <a href="sysreq.html#S30100">S30100</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12019</td><td valign="top">When <a href="c3ref/close.html">sqlite3_close(C)</a> is invoked on a <a href="c3ref/sqlite3.html">database connection</a> C
that has a pending transaction, the transaction shall be
rolled back. <p>Parents: <a href="sysreq.html#S30100">S30100</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12100</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_exec(
  sqlite3*,                                  /* An open database */
  const char *sql,                           /* SQL to be evaluated */
  int (*callback)(void*,int,char**,char**),  /* Callback function */
  void *,                                    /* 1st argument to callback */
  char **errmsg                              /* Error msg written here */
);

</pre></blockquote><p>Parents: <a href="sysreq.html#S10000">S10000</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12101</td><td valign="top">A successful invocation of <a href="c3ref/exec.html">sqlite3_exec(D,S,C,A,E)</a>
shall sequentially evaluate all of the UTF-8 encoded,
semicolon-separated SQL statements in the zero-terminated
string S within the context of the <a href="c3ref/sqlite3.html">database connection</a> D. <p>Parents: <a href="sysreq.html#S10000">S10000</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12102</td><td valign="top">If the S parameter to <a href="c3ref/exec.html">sqlite3_exec(D,S,C,A,E)</a> is NULL then
the actions of the interface shall be the same as if the
S parameter were an empty string. <p>Parents: <a href="sysreq.html#S10000">S10000</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12104</td><td valign="top">The return value of <a href="c3ref/exec.html">sqlite3_exec()</a> shall be <a href="c3ref/c_abort.html">SQLITE_OK</a> if all
SQL statements run successfully and to completion. <p>Parents: <a href="sysreq.html#S10000">S10000</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12105</td><td valign="top">The return value of <a href="c3ref/exec.html">sqlite3_exec()</a> shall be an appropriate
non-zero <a href="c3ref/c_abort.html">error code</a> if any SQL statement fails. <p>Parents: <a href="sysreq.html#S10000">S10000</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12107</td><td valign="top">If one or more of the SQL statements handed to <a href="c3ref/exec.html">sqlite3_exec()</a>
return results and the 3rd parameter is not NULL, then
the callback function specified by the 3rd parameter shall be
invoked once for each row of result. <p>Parents: <a href="sysreq.html#S10000">S10000</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12110</td><td valign="top">If the callback returns a non-zero value then <a href="c3ref/exec.html">sqlite3_exec()</a>
shall abort the SQL statement it is currently evaluating,
skip all subsequent SQL statements, and return <a href="c3ref/c_abort.html">SQLITE_ABORT</a>. <p>Parents: <a href="sysreq.html#S10000">S10000</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12113</td><td valign="top">The <a href="c3ref/exec.html">sqlite3_exec()</a> routine shall pass its 4th parameter through
as the 1st parameter of the callback. <p>Parents: <a href="sysreq.html#S10000">S10000</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12116</td><td valign="top">The <a href="c3ref/exec.html">sqlite3_exec()</a> routine shall set the 2nd parameter of its
callback to be the number of columns in the current row of
result. <p>Parents: <a href="sysreq.html#S10000">S10000</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12119</td><td valign="top">The <a href="c3ref/exec.html">sqlite3_exec()</a> routine shall set the 3rd parameter of its
callback to be an array of pointers to strings holding the
values for each column in the current result set row as
obtained from <a href="c3ref/column_blob.html">sqlite3_column_text()</a>. <p>Parents: <a href="sysreq.html#S10000">S10000</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12122</td><td valign="top">The <a href="c3ref/exec.html">sqlite3_exec()</a> routine shall set the 4th parameter of its
callback to be an array of pointers to strings holding the
names of result columns as obtained from <a href="c3ref/column_name.html">sqlite3_column_name()</a>. <p>Parents: <a href="sysreq.html#S10000">S10000</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12125</td><td valign="top">If the 3rd parameter to <a href="c3ref/exec.html">sqlite3_exec()</a> is NULL then
<a href="c3ref/exec.html">sqlite3_exec()</a> shall silently discard query results. <p>Parents: <a href="sysreq.html#S10000">S10000</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12131</td><td valign="top">If an error occurs while parsing or evaluating any of the SQL
statements in the S parameter of <a href="c3ref/exec.html">sqlite3_exec(D,S,C,A,E)</a> and if
the E parameter is not NULL, then <a href="c3ref/exec.html">sqlite3_exec()</a> shall store
in *E an appropriate error message written into memory obtained
from <a href="c3ref/free.html">sqlite3_malloc()</a>. <p>Parents: <a href="sysreq.html#S10000">S10000</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12134</td><td valign="top">The <a href="c3ref/exec.html">sqlite3_exec(D,S,C,A,E)</a> routine shall set the value of
*E to NULL if E is not NULL and there are no errors. <p>Parents: <a href="sysreq.html#S10000">S10000</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12137</td><td valign="top">The <a href="c3ref/exec.html">sqlite3_exec(D,S,C,A,E)</a> function shall set the <a href="c3ref/c_abort.html">error code</a>
and message accessible via <a href="c3ref/errcode.html">sqlite3_errcode()</a>,
<a href="c3ref/errcode.html">sqlite3_extended_errcode()</a>,
<a href="c3ref/errcode.html">sqlite3_errmsg()</a>, and <a href="c3ref/errcode.html">sqlite3_errmsg16()</a>. <p>Parents: <a href="sysreq.html#S10000">S10000</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12138</td><td valign="top">If the S parameter to <a href="c3ref/exec.html">sqlite3_exec(D,S,C,A,E)</a> is NULL or an
empty string or contains nothing other than whitespace, comments,
and/or semicolons, then results of <a href="c3ref/errcode.html">sqlite3_errcode()</a>,
<a href="c3ref/errcode.html">sqlite3_extended_errcode()</a>,
<a href="c3ref/errcode.html">sqlite3_errmsg()</a>, and <a href="c3ref/errcode.html">sqlite3_errmsg16()</a>
shall reset to indicate no errors. <p>Parents: <a href="sysreq.html#S10000">S10000</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12200</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_extended_result_codes(sqlite3*, int onoff);

</pre></blockquote><p>Parents: <a href="sysreq.html#S10700">S10700</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12201</td><td valign="top">Each new <a href="c3ref/sqlite3.html">database connection</a> shall have the
<a href="c3ref/c_ioerr_access.html">extended result codes</a> feature disabled by default. <p>Parents: <a href="sysreq.html#S10700">S10700</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12202</td><td valign="top">The <a href="c3ref/extended_result_codes.html">sqlite3_extended_result_codes(D,F)</a> interface shall enable
<a href="c3ref/c_ioerr_access.html">extended result codes</a> for the  <a href="c3ref/sqlite3.html">database connection</a> D
if the F parameter is true, or disable them if F is false. <p>Parents: <a href="sysreq.html#S10700">S10700</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12220</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
sqlite3_int64 sqlite3_last_insert_rowid(sqlite3*);

</pre></blockquote><p>Parents: <a href="sysreq.html#S10700">S10700</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12221</td><td valign="top">The <a href="c3ref/last_insert_rowid.html">sqlite3_last_insert_rowid()</a> function shall return the rowid
of the most recent successful <a href="lang_insert.html">INSERT</a> performed on the same
<a href="c3ref/sqlite3.html">database connection</a> and within the same or higher level
trigger context, or zero if there have been no qualifying
<a href="lang_insert.html">INSERT</a> statements. <p>Parents: <a href="sysreq.html#S10700">S10700</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12223</td><td valign="top">The <a href="c3ref/last_insert_rowid.html">sqlite3_last_insert_rowid()</a> function shall return the
same value when called from the same trigger context
immediately before and after a <a href="lang_transaction.html">ROLLBACK</a>. <p>Parents: <a href="sysreq.html#S10700">S10700</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12240</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_changes(sqlite3*);

</pre></blockquote><p>Parents: <a href="sysreq.html#S10600">S10600</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12241</td><td valign="top">The <a href="c3ref/changes.html">sqlite3_changes()</a> function shall return the number of
row changes caused by the most recent INSERT, UPDATE,
or DELETE statement on the same database connection and
within the same or higher trigger context, or zero if there have
not been any qualifying row changes. <p>Parents: <a href="sysreq.html#S10600">S10600</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12243</td><td valign="top">Statements of the form "DELETE FROM tablename" with no
WHERE clause shall cause subsequent calls to
<a href="c3ref/changes.html">sqlite3_changes()</a> to return zero, regardless of the
number of rows originally in the table. <p>Parents: <a href="sysreq.html#S10600">S10600</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12260</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_total_changes(sqlite3*);

</pre></blockquote><p>Parents: <a href="sysreq.html#S10600">S10600</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12261</td><td valign="top">The <a href="c3ref/total_changes.html">sqlite3_total_changes()</a> returns the total number
of row changes caused by INSERT, UPDATE, and/or DELETE
statements on the same <a href="c3ref/sqlite3.html">database connection</a>, in any
trigger context, since the database connection was created. <p>Parents: <a href="sysreq.html#S10600">S10600</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12263</td><td valign="top">Statements of the form "DELETE FROM tablename" with no
WHERE clause shall not change the value returned
by <a href="c3ref/total_changes.html">sqlite3_total_changes()</a>. <p>Parents: <a href="sysreq.html#S10600">S10600</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12270</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
void sqlite3_interrupt(sqlite3*);

</pre></blockquote><p>Parents: <a href="sysreq.html#S30500">S30500</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12271</td><td valign="top">The <a href="c3ref/interrupt.html">sqlite3_interrupt()</a> interface will force all running
SQL statements associated with the same database connection
to halt after processing at most one additional row of data. <p>Parents: <a href="sysreq.html#S30500">S30500</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12272</td><td valign="top">Any SQL statement that is interrupted by <a href="c3ref/interrupt.html">sqlite3_interrupt()</a>
will return <a href="c3ref/c_abort.html">SQLITE_INTERRUPT</a>. <p>Parents: <a href="sysreq.html#S30500">S30500</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12280</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
void *sqlite3_trace(sqlite3*, void(*xTrace)(void*,const char*), void*);
void *sqlite3_profile(sqlite3*,
   void(*xProfile)(void*,const char*,sqlite3_uint64), void*);

</pre></blockquote><p>Parents: <a href="sysreq.html#S60400">S60400</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12281</td><td valign="top">The callback function registered by <a href="c3ref/profile.html">sqlite3_trace()</a>
shall be invoked
whenever an SQL statement first begins to execute and
whenever a trigger subprogram first begins to run. <p>Parents: <a href="sysreq.html#S60400">S60400</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12282</td><td valign="top">Each call to <a href="c3ref/profile.html">sqlite3_trace()</a> shall override the previously
registered trace callback. <p>Parents: <a href="sysreq.html#S60400">S60400</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12283</td><td valign="top">A NULL trace callback shall disable tracing. <p>Parents: <a href="sysreq.html#S60400">S60400</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12284</td><td valign="top">The first argument to the trace callback shall be a copy of
the pointer which was the 3rd argument to <a href="c3ref/profile.html">sqlite3_trace()</a>. <p>Parents: <a href="sysreq.html#S60400">S60400</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12285</td><td valign="top">The second argument to the trace callback is a
zero-terminated UTF-8 string containing the original text
of the SQL statement as it was passed into <a href="c3ref/prepare.html">sqlite3_prepare_v2()</a>
or the equivalent, or an SQL comment indicating the beginning
of a trigger subprogram. <p>Parents: <a href="sysreq.html#S60400">S60400</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12287</td><td valign="top">The callback function registered by <a href="c3ref/profile.html">sqlite3_profile()</a> is invoked
as each SQL statement finishes. <p>Parents: <a href="sysreq.html#S60400">S60400</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12288</td><td valign="top">The first parameter to the profile callback is a copy of
the 3rd parameter to <a href="c3ref/profile.html">sqlite3_profile()</a>. <p>Parents: <a href="sysreq.html#S60400">S60400</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12289</td><td valign="top">The second parameter to the profile callback is a
zero-terminated UTF-8 string that contains the complete text of
the SQL statement as it was processed by <a href="c3ref/prepare.html">sqlite3_prepare_v2()</a>
or the equivalent. <p>Parents: <a href="sysreq.html#S60400">S60400</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12290</td><td valign="top">The third parameter to the profile callback is an estimate
of the number of nanoseconds of wall-clock time required to
run the SQL statement from start to finish. <p>Parents: <a href="sysreq.html#S60400">S60400</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12310</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_busy_handler(sqlite3*, int(*)(void*,int), void*);

</pre></blockquote><p>Parents: <a href="sysreq.html#S40400">S40400</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12311</td><td valign="top">The <a href="c3ref/busy_handler.html">sqlite3_busy_handler(D,C,A)</a> function shall replace
busy callback in the <a href="c3ref/sqlite3.html">database connection</a> D with a new
a new busy handler C and application data pointer A. <p>Parents: <a href="sysreq.html#S40400">S40400</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12312</td><td valign="top">Newly created <a href="c3ref/sqlite3.html">database connections</a> shall have a busy
handler of NULL. <p>Parents: <a href="sysreq.html#S40400">S40400</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12314</td><td valign="top">When two or more <a href="c3ref/sqlite3.html">database connections</a> share a
<a href="c3ref/enable_shared_cache.html">common cache</a>,
the busy handler for the database connection currently using
the cache shall be invoked when the cache encounters a lock. <p>Parents: <a href="sysreq.html#S40400">S40400</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12316</td><td valign="top">If a busy handler callback returns zero, then the SQLite interface
that provoked the locking event shall return <a href="c3ref/c_abort.html">SQLITE_BUSY</a>. <p>Parents: <a href="sysreq.html#S40400">S40400</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12318</td><td valign="top">SQLite shall invokes the busy handler with two arguments which
are a copy of the pointer supplied by the 3rd parameter to
<a href="c3ref/busy_handler.html">sqlite3_busy_handler()</a> and a count of the number of prior
invocations of the busy handler for the same locking event. <p>Parents: <a href="sysreq.html#S40400">S40400</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12340</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_busy_timeout(sqlite3*, int ms);

</pre></blockquote><p>Parents: <a href="sysreq.html#S40410">S40410</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12341</td><td valign="top">The <a href="c3ref/busy_timeout.html">sqlite3_busy_timeout()</a> function shall override any prior
<a href="c3ref/busy_timeout.html">sqlite3_busy_timeout()</a> or <a href="c3ref/busy_handler.html">sqlite3_busy_handler()</a> setting
on the same <a href="c3ref/sqlite3.html">database connection</a>. <p>Parents: <a href="sysreq.html#S40410">S40410</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12343</td><td valign="top">If the 2nd parameter to <a href="c3ref/busy_timeout.html">sqlite3_busy_timeout()</a> is less than
or equal to zero, then the busy handler shall be cleared so that
all subsequent locking events immediately return <a href="c3ref/c_abort.html">SQLITE_BUSY</a>. <p>Parents: <a href="sysreq.html#S40410">S40410</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12344</td><td valign="top">If the 2nd parameter to <a href="c3ref/busy_timeout.html">sqlite3_busy_timeout()</a> is a positive
number N, then a busy handler shall be set that repeatedly calls
the xSleep() method in the <a href="c3ref/vfs.html">VFS interface</a> until
either the lock clears or until the cumulative sleep time
reported back by xSleep() exceeds N milliseconds. <p>Parents: <a href="sysreq.html#S40410">S40410</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12370</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_get_table(
  sqlite3 *db,          /* An open database */