trace1.html

sqlite的帮助文档

the following interfaces:
<blockquote><pre>
int sqlite3_close(sqlite3 *);

</pre></blockquote><ol><li value="1"><p>S30100
  The SQLite library shall release all system resources it holds
  when it is properly shutdown.
</p></li><li value="2"><p>S30000
  The SQLite library shall be safe for use in long-running,
  low-resource, high-reliability applications.
</p></li><li value="1"><p>S40200
  The SQLite library shall support multiple independent database
  connections per thread and per process.
</p></li><li value="2"><p>S40000
  The SQLite library shall be safe for use in applications that
  make concurrent access to the underlying database from different
  threads and/or processes.
</p></li></ol></td></tr><tr><td valign="top">H12011</td><td valign="top">A successful call to <a href="c3ref/close.html">sqlite3_close(C)</a> shall destroy the
<a href="c3ref/sqlite3.html">database connection</a> object C. <ol><li value="1"><p>S30100
  The SQLite library shall release all system resources it holds
  when it is properly shutdown.
</p></li><li value="2"><p>S30000
  The SQLite library shall be safe for use in long-running,
  low-resource, high-reliability applications.
</p></li></ol></td></tr><tr><td valign="top">H12012</td><td valign="top">A successful call to <a href="c3ref/close.html">sqlite3_close(C)</a> shall return SQLITE_OK. <ol><li value="1"><p>S30100
  The SQLite library shall release all system resources it holds
  when it is properly shutdown.
</p></li><li value="2"><p>S30000
  The SQLite library shall be safe for use in long-running,
  low-resource, high-reliability applications.
</p></li></ol></td></tr><tr><td valign="top">H12013</td><td valign="top">A successful call to <a href="c3ref/close.html">sqlite3_close(C)</a> shall release all
memory and system resources associated with <a href="c3ref/sqlite3.html">database connection</a>
C. <ol><li value="1"><p>S30100
  The SQLite library shall release all system resources it holds
  when it is properly shutdown.
</p></li><li value="2"><p>S30000
  The SQLite library shall be safe for use in long-running,
  low-resource, high-reliability applications.
</p></li></ol></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. <ol><li value="1"><p>S30100
  The SQLite library shall release all system resources it holds
  when it is properly shutdown.
</p></li><li value="2"><p>S30000
  The SQLite library shall be safe for use in long-running,
  low-resource, high-reliability applications.
</p></li></ol></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. <ol><li value="1"><p>S30100
  The SQLite library shall release all system resources it holds
  when it is properly shutdown.
</p></li><li value="2"><p>S30000
  The SQLite library shall be safe for use in long-running,
  low-resource, high-reliability applications.
</p></li></ol></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. <ol><li value="1"><p>S30100
  The SQLite library shall release all system resources it holds
  when it is properly shutdown.
</p></li><li value="2"><p>S30000
  The SQLite library shall be safe for use in long-running,
  low-resource, high-reliability applications.
</p></li></ol></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><ol><li value="1"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li></ol></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. <ol><li value="1"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li></ol></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. <ol><li value="1"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li></ol></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. <ol><li value="1"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li></ol></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. <ol><li value="1"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li></ol></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. <ol><li value="1"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li></ol></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>. <ol><li value="1"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li></ol></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. <ol><li value="1"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li></ol></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. <ol><li value="1"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li></ol></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>. <ol><li value="1"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li></ol></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>. <ol><li value="1"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li></ol></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. <ol><li value="1"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li></ol></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>. <ol><li value="1"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li></ol></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. <ol><li value="1"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li></ol></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>. <ol><li value="1"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li></ol></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. <ol><li value="1"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li></ol></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><ol><li value="1"><p>S10700
  The SQLite library shall provide interfaces that allow the application
  to obtain the status and results of SQL operations.
</p></li><li value="2"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li></ol></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. <ol><li value="1"><p>S10700
  The SQLite library shall provide interfaces that allow the application
  to obtain the status and results of SQL operations.
</p></li><li value="2"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li></ol></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. <ol><li value="1"><p>S10700
  The SQLite library shall provide interfaces that allow the application
  to obtain the status and results of SQL operations.
</p></li><li value="2"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li></ol></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><ol><li value="1"><p>S10700
  The SQLite library shall provide interfaces that allow the application
  to obtain the status and results of SQL operations.
</p></li><li value="2"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li></ol></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. <ol><li value="1"><p>S10700
  The SQLite library shall provide interfaces that allow the application
  to obtain the status and results of SQL operations.
</p></li><li value="2"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li></ol></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>. <ol><li value="1"><p>S10700
  The SQLite library shall provide interfaces that allow the application
  to obtain the status and results of SQL operations.
</p></li><li value="2"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li></ol></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><ol><li value="1"><p>S10600  
  The SQLite library shall support simultaneous access to multiple
  database files on the same database connection.
</p></li><li value="2"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li></ol></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. <ol><li value="1"><p>S10600  
  The SQLite library shall support simultaneous access to multiple
  database files on the same database connection.
</p></li><li value="2"><p>S10000
  The SQLite library shall translate high-level SQL statements into
  low-level I/O calls to persistent storage.
</p></li></ol></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. <ol><li value="1"><p>S10600  
  The SQLite library shall support simultaneous access to multiple
  database files on the same database connection.
</p></li><li value="2"><p>