hlreq.html

sqlite的帮助文档

not been any qualifying row changes. </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. </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></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. </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>. </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></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. </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>. </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></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. </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. </td></tr><tr><td valign="top">H12283</td><td valign="top">A NULL trace callback shall disable tracing. </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>. </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. </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. </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>. </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. </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. </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></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. </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. </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. </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>. </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. </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></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>. </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>. </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. </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 */
  const char *zSql,     /* SQL to be evaluated */
  char ***pazResult,    /* Results of the query */
  int *pnRow,           /* Number of result rows written here */
  int *pnColumn,        /* Number of result columns written here */
  char **pzErrmsg       /* Error msg written here */
);
void sqlite3_free_table(char **result);

</pre></blockquote></td></tr><tr><td valign="top">H12371</td><td valign="top">If a <a href="c3ref/free_table.html">sqlite3_get_table()</a> fails a memory allocation, then
it shall free the result table under construction, abort the
query in process, skip any subsequent queries, set the
*pazResult output pointer to NULL and return <a href="c3ref/c_abort.html">SQLITE_NOMEM</a>. </td></tr><tr><td valign="top">H12373</td><td valign="top">If the pnColumn parameter to <a href="c3ref/free_table.html">sqlite3_get_table()</a> is not NULL
then a successful invocation of <a href="c3ref/free_table.html">sqlite3_get_table()</a> shall
write the number of columns in the
result set of the query into *pnColumn. </td></tr><tr><td valign="top">H12374</td><td valign="top">If the pnRow parameter to <a href="c3ref/free_table.html">sqlite3_get_table()</a> is not NULL
then a successful invocation of <a href="c3ref/free_table.html">sqlite3_get_table()</a> shall
writes the number of rows in the
result set of the query into *pnRow. </td></tr><tr><td valign="top">H12376</td><td valign="top">A successful invocation of <a href="c3ref/free_table.html">sqlite3_get_table()</a> that computes
N rows of result with C columns per row shall make *pazResult
point to an array of pointers to (N+1)*C strings where the first
C strings are column names as obtained from
<a href="c3ref/column_name.html">sqlite3_column_name()</a> and the rest are column result values
obtained from <a href="c3ref/column_blob.html">sqlite3_column_text()</a>. </td></tr><tr><td valign="top">H12379</td><td valign="top">The values in the pazResult array returned by <a href="c3ref/free_table.html">sqlite3_get_table()</a>
shall remain valid until cleared by <a href="c3ref/free_table.html">sqlite3_free_table()</a>. </td></tr><tr><td valign="top">H12382</td><td valign="top">When an error occurs during evaluation of <a href="c3ref/free_table.html">sqlite3_get_table()</a>
the function shall set *pazResult to NULL, write an error message
into memory obtained from <a href="c3ref/free.html">sqlite3_malloc()</a>, make
**pzErrmsg point to that error message, and return a
appropriate <a href="c3ref/c_abort.html">error code</a>. </td></tr><tr><td valign="top">H12500</td><td valign="top">The sqlite3.h header file shall define the
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><tr><td valign="top">H12501</td><td valign="top">The <a href="c3ref/set_authorizer.html">sqlite3_set_authorizer(D,...)</a> interface registers a
authorizer callback with database connection D. </td></tr><tr><td valign="top">H12502</td><td valign="top">The authorizer callback is invoked as SQL statements are
being parseed and compiled. </td></tr><tr><td valign="top">H12503</td><td valign="top">If the authorizer callback returns any value other than
<a href="c3ref/c_deny.html">SQLITE_IGNORE</a>, <a href="c3ref/c_abort.html">SQLITE_OK</a>, or <a href="c3ref/c_deny.html">SQLITE_DENY</a>, then
the application interface call that caused
the authorizer callback to run shall fail with an
<a href="c3ref/c_abort.html">SQLITE_ERROR</a> error code and an appropriate error message. </td></tr><tr><td valign="top">H12504</td><td valign="top">When the authorizer callback returns <a href="c3ref/c_abort.html">SQLITE_OK</a>, the operation
described is processed normally. </td></tr><tr><td valign="top">H12505</td><td valign="top">When the authorizer callback returns <a href="c3ref/c_deny.html">SQLITE_DENY</a>, the
application interface call that caused the
authorizer callback to run shall fail
with an <a href="c3ref/c_abort.html">SQLITE_ERROR</a> error code and an error message
explaining that access is denied. </td></tr><tr><td valign="top">H12506</td><td valign="top">If the authorizer code (the 2nd parameter to the authorizer
callback) is <a href="c3ref/c_alter_table.html">SQLITE_READ</a> and the authorizer callback returns
<a href="c3ref/c_deny.html">SQLITE_IGNORE</a>, then the prepared statement is constructed to
insert a NULL value in place of the table column that would have
been read if <a href="c3ref/c_abort.html">SQLITE_OK</a> had been returned. </td></tr><tr><td valign="top">H12507</td><td valign="top">If the authorizer code (the 2nd parameter to the authorizer
callback) is anything other than <a href="c3ref/c_alter_table.html">SQLITE_READ</a>, then
a return of <a href="c3ref/c_deny.html">SQLITE_IGNORE</a> has the same effect as <a href="c3ref/c_deny.html">SQLITE_DENY</a>. </td></tr><tr><td valign="top">H12510</td><td valign="top">The first parameter to the authorizer callback is a copy of
the third parameter to the <a href="c3ref/set_authorizer.html">sqlite3_set_authorizer()</a> interface. </td></tr><tr><td valign="top">H12511</td><td valign="top">The second parameter to the callback is an integer
<a href="c3ref/c_alter_table.html">action code</a> that specifies the particular action
to be authorized. </td></tr><tr><td valign="top">H12512</td><td valign="top">The third through sixth parameters to the callback are
zero-terminated strings that contain
additional details about the action to be authorized. </td></tr><tr><td valign="top">H12520</td><td valign="top">Each call to <a href="c3ref/set_authorizer.html">sqlite3_set_authorizer()</a> overrides
any previously installed authorizer. </td></tr><tr><td valign="top">H12521</td><td valign="top">A NULL authorizer means that no authorization
callback is invoked. </td></tr><tr><td valign="top">H12522</td><td valign="top">The default authorizer is NULL. </td></tr><tr><td valign="top">H12550</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
/******************************************* 3rd ************ 4th ***********/
#define SQLITE_CREATE_INDEX          1   /* Index Name      Table Name      */
#define SQLITE_CREATE_TABLE          2   /* Table Name      NULL            */
#define SQLITE_CREATE_TEMP_INDEX     3   /* Index Name      Table Name      */
#define SQLITE_CREATE_TEMP_TABLE     4   /* Table Name      NULL            */
#define SQLITE_CREATE_TEMP_TRIGGER   5   /* Trigger Name    Table Name      */
#define SQLITE_CREATE_TEMP_VIEW      6   /* View Name       NULL            */
#define SQLITE_CREATE_TRIGGER        7   /* Trigger Name    Table Name      */
#define SQLITE_CREATE_VIEW           8   /* View Name       NULL            */
#define SQLITE_DELETE                9   /* Table Name      NULL            */
#define SQLITE_DROP_INDEX           10   /* Index Name      Table Name      */
#define SQLITE_DROP_TABLE           11   /* Table Name      NULL            */
#define SQLITE_DROP_TEMP_INDEX      12   /* Index Name      Table Name      */
#define SQLITE_DROP_TEMP_TABLE      13   /* Table Name      NULL            */
#define SQLITE_DROP_TEMP_TRIGGER    14   /* Trigger Name    Table Name      */
#define SQLITE_DROP_TEMP_VIEW       15   /* View Name       NULL            */
#define SQLITE_DROP_TRIGGER         16   /* Trigger Name    Table Name      */
#define SQLITE_DROP_VIEW            17   /* View Name       NULL            */
#define SQLITE_INSERT               18   /* Table Name      NULL            */
#define SQLITE_PRAGMA               19   /* Pragma Name     1st arg or NULL */
#define SQLITE_READ                 20   /* Table Name      Column Name     */
#define SQLITE_SELECT               21   /* NULL            NULL            */
#define SQLITE_TRANSACTION          22   /* NULL            NULL            */
#define SQLITE_UPDATE               23   /* Table Name      Column Name     */
#define SQLITE_ATTACH               24   /* Filename        NULL            */
#define SQLITE_DETACH               25   /* Database Name   NULL            */
#define SQLITE_ALTER_TABLE          26   /* Database Name   Table Name      */
#define SQLITE_REINDEX              27   /* Index Name      NULL            */
#define SQLITE_ANALYZE              28   /* Table Name      NULL            */
#define SQLITE_CREATE_VTABLE        29   /* Table Name      Module Name     */
#define SQLITE_DROP_VTABLE          30   /* Table Name      Module Name     */
#define SQLITE_FUNCTION             31   /* NULL            Function Name   */
#define SQLITE_COPY                  0   /* No longer used */

</pre></blockquote></td></tr><tr><td valign="top">H12551</td><td valign="top">The second parameter to an
<a href="c3ref/set_authorizer.html">authorizer callback</a> shall be an integer
<a href="c3ref/c_alter_table.html">authorizer code</a> that specifies what action
is being authorized. </td></tr><tr><td valign="top">H12552</td><td valign="top">The 3rd and 4th parameters to the
<a href="c3ref/set_authorizer.html">authorization callback</a>
shall be parameters or NULL depending on which
<a href="c3ref/c_alter_table.html">authorizer code</a> is used as the second parameter. </td></tr><tr><td valign="top">H12553</td><td valign="top">The 5th parameter to the