requirements.html

SQLite is a software library that implements a self-contained, serverless, zero-configuration, trans

as the 1st parameter of the callback.
</td></tr>
<tr><td valign="top">F12116</td><td valign="top">
The 
<a href="c3ref/exec.html">sqlite3_exec()</a> routine sets the 2nd parameter of its
callback to be the number of columns in the current row of
result.
</td></tr>
<tr><td valign="top">F12119</td><td valign="top">
The 
<a href="c3ref/exec.html">sqlite3_exec()</a> routine sets 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>.
</td></tr>
<tr><td valign="top">F12122</td><td valign="top">
The 
<a href="c3ref/exec.html">sqlite3_exec()</a> routine sets 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>.
</td></tr>
<tr><td valign="top">F12125</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> never invokes a callback.  All query
results are silently discarded.
</td></tr>
<tr><td valign="top">F12128</td><td valign="top">
If an error occurs while parsing or evaluating any of the SQL
statements handed to 
<a href="c3ref/exec.html">sqlite3_exec()</a> then 
<a href="c3ref/exec.html">sqlite3_exec()</a> will
return an 
<a href="c3ref/c_abort.html">error code</a> other than 
<a href="c3ref/c_abort.html">SQLITE_OK</a>.
</td></tr>
<tr><td valign="top">F12131</td><td valign="top">
If an error occurs while parsing or evaluating any of the SQL
handed to 
<a href="c3ref/exec.html">sqlite3_exec()</a> and if the 5th parameter (errmsg)
to 
<a href="c3ref/exec.html">sqlite3_exec()</a> is not NULL, then an error message is
allocated using the equivalent of 
<a href="c3ref/mprintf.html">sqlite3_mprintf()</a> and
*errmsg is made to point to that message.
</td></tr>
<tr><td valign="top">F12134</td><td valign="top">
The 
<a href="c3ref/exec.html">sqlite3_exec()</a> routine does not change the value of
*errmsg if errmsg is NULL or if there are no errors.
</td></tr>
<tr><td valign="top">F12137</td><td valign="top">
The 
<a href="c3ref/exec.html">sqlite3_exec()</a> function sets the error code and message
accessible via 
<a href="c3ref/errcode.html">sqlite3_errcode()</a>, 
<a href="c3ref/errcode.html">sqlite3_errmsg()</a>, and

<a href="c3ref/errcode.html">sqlite3_errmsg16()</a>.
</td></tr>
<tr><td valign="top">F12200</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
int sqlite3_extended_result_codes(sqlite3*, int onoff);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F12201</td><td valign="top">
Each new 
<a href="c3ref/sqlite3.html">database connection</a> has the

<a href="c3ref/c_ioerr_blocked.html">extended result codes</a> feature
disabled by default.
</td></tr>
<tr><td valign="top">F12202</td><td valign="top">
The 
<a href="c3ref/extended_result_codes.html">sqlite3_extended_result_codes(D,F)</a> interface will enable

<a href="c3ref/c_ioerr_blocked.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.
</td></tr>
<tr><td valign="top">F12220</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
sqlite3_int64 sqlite3_last_insert_rowid(sqlite3*);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F12221</td><td valign="top">
The 
<a href="c3ref/last_insert_rowid.html">sqlite3_last_insert_rowid()</a> function returns the
rowid of the most recent successful insert done
on the same database connection and within the same
trigger context, or zero if there have
been no qualifying inserts on that connection.
</td></tr>
<tr><td valign="top">F12223</td><td valign="top">
The 
<a href="c3ref/last_insert_rowid.html">sqlite3_last_insert_rowid()</a> function returns
same value when called from the same trigger context
immediately before and after a ROLLBACK.
</td></tr>
<tr><td valign="top">F12240</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
int sqlite3_changes(sqlite3*);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F12241</td><td valign="top">
The 
<a href="c3ref/changes.html">sqlite3_changes()</a> function returns the number of
row changes caused by the most recent INSERT, UPDATE,
or DELETE statement on the same database connection and
within the same trigger context, or zero if there have
not been any qualifying row changes.
</td></tr>
<tr><td valign="top">F12260</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
int sqlite3_total_changes(sqlite3*);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F12261</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.
</td></tr>
<tr><td valign="top">F12270</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
void sqlite3_interrupt(sqlite3*);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F12271</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.
</td></tr>
<tr><td valign="top">F12272</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>.
</td></tr>
<tr><td valign="top">F12280</td><td valign="top">
The sqlite3.h header file defines 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>
</td></tr>
<tr><td valign="top">F12281</td><td valign="top">
The callback function registered by 
<a href="c3ref/profile.html">sqlite3_trace()</a> is
whenever an SQL statement first begins to execute and
whenever a trigger subprogram first begins to run.
</td></tr>
<tr><td valign="top">F12282</td><td valign="top">
Each call to 
<a href="c3ref/profile.html">sqlite3_trace()</a> overrides the previously
registered trace callback.
</td></tr>
<tr><td valign="top">F12283</td><td valign="top">
A NULL trace callback disables tracing.
</td></tr>
<tr><td valign="top">F12284</td><td valign="top">
The first argument to the trace callback is a copy of
the pointer which was the 3rd argument to 
<a href="c3ref/profile.html">sqlite3_trace()</a>.
</td></tr>
<tr><td valign="top">F12285</td><td valign="top">
The second argument to the trace callback is a
zero-terminated UTF8 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.
</td></tr>
<tr><td valign="top">F12287</td><td valign="top">
The callback function registered by 
<a href="c3ref/profile.html">sqlite3_profile()</a> is invoked
as each SQL statement finishes.
</td></tr>
<tr><td valign="top">F12288</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>.
</td></tr>
<tr><td valign="top">F12289</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.
</td></tr>
<tr><td valign="top">F12290</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.
</td></tr>
<tr><td valign="top">F12310</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
int sqlite3_busy_handler(sqlite3*, int(*)(void*,int), void*);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F12311</td><td valign="top">
The 
<a href="c3ref/busy_handler.html">sqlite3_busy_handler()</a> function replaces the busy handler
callback in the database connection identified by the 1st
parameter with a new busy handler identified by the 2nd and 3rd
parameters.
</td></tr>
<tr><td valign="top">F12312</td><td valign="top">
The default busy handler for new database connections is NULL.
</td></tr>
<tr><td valign="top">F12314</td><td valign="top">
When two or more database connection share a common cache,
the busy handler for the database connection currently using
the cache is invoked when the cache encounters a lock.
</td></tr>
<tr><td valign="top">F12316</td><td valign="top">
If a busy handler callback returns zero, then the SQLite
interface that provoked the locking event will return

<a href="c3ref/c_abort.html">SQLITE_BUSY</a>.
</td></tr>
<tr><td valign="top">F12318</td><td valign="top">
SQLite will invokes the busy handler with two argument 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.
</td></tr>
<tr><td valign="top">F12340</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
int sqlite3_busy_timeout(sqlite3*, int ms);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F12341</td><td valign="top">
The 
<a href="c3ref/busy_timeout.html">sqlite3_busy_timeout()</a> function overrides 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 database connection.
</td></tr>
<tr><td valign="top">F12343</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 is cleared so that
all subsequent locking events immediately return 
<a href="c3ref/c_abort.html">SQLITE_BUSY</a>.
</td></tr>
<tr><td valign="top">F12344</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 is set that repeatedly calls
the xSleep() method in the VFS interface until either the
lock clears or until the cumulative sleep time reported back
by xSleep() exceeds N milliseconds.
</td></tr>
<tr><td valign="top">F12370</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
int sqlite3_get_table(
  sqlite3*,             /* An open database */
  const char *sql,      /* SQL to be evaluated */
  char ***pResult,      /* Results of the query */
  int *nrow,            /* Number of result rows written here */
  int *ncolumn,         /* Number of result columns written here */
  char **errmsg         /* Error msg written here */
);
void sqlite3_free_table(char **result);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F12371</td><td valign="top">
If a 
<a href="c3ref/free_table.html">sqlite3_get_table()</a> fails a memory allocation, then
it frees the result table under construction, aborts the
query in process, skips any subsequent queries, sets the
*resultp output pointer to NULL and returns 
<a href="c3ref/c_abort.html">SQLITE_NOMEM</a>.
</td></tr>
<tr><td valign="top">F12373</td><td valign="top">
If the ncolumn parameter to 
<a href="c3ref/free_table.html">sqlite3_get_table()</a> is not NULL
then 
<a href="c3ref/free_table.html">sqlite3_get_table()</a> write the number of columns in the
result set of the query into *ncolumn if the query is
successful (if the function returns SQLITE_OK).
</td></tr>
<tr><td valign="top">F12374</td><td valign="top">
If the nrow parameter to 
<a href="c3ref/free_table.html">sqlite3_get_table()</a> is not NULL
then 
<a href="c3ref/free_table.html">sqlite3_get_table()</a> write the number of rows in the
result set of the query into *nrow if the query is
successful (if the function returns SQLITE_OK).
</td></tr>
<tr><td valign="top">F12376</td><td valign="top">
The 
<a href="c3ref/free_table.html">sqlite3_get_table()</a> function sets its *ncolumn value
to the number of columns in the result set of the query in the
sql parameter, or to zero if the query in sql has an empty
result set.
</td></tr>
<tr><td valign="top">F12500</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
int sqlite3_set_authorizer(
  sqlite3*,
  int (*xAuth)(void*,int,const char*,const char*,const char*,const char*),
  void *pUserData
);

</pre></blockquote>
</td></tr>