reqmatrix.html

sqlite的帮助文档

  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><p>Parents: <a href="sysreq.html#S10000">S10000</a></p><p><i>No children</i></p></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>. <p>Parents: <a href="sysreq.html#S10000">S10000</a></p><p><i>No children</i></p></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. <p>Parents: <a href="sysreq.html#S10000">S10000</a></p><p><i>No children</i></p></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. <p>Parents: <a href="sysreq.html#S10000">S10000</a></p><p><i>No children</i></p></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>. <p>Parents: <a href="sysreq.html#S10000">S10000</a></p><p><i>No children</i></p></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>. <p>Parents: <a href="sysreq.html#S10000">S10000</a></p><p><i>No children</i></p></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>. <p>Parents: <a href="sysreq.html#S10000">S10000</a></p><p><i>No children</i></p></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><p>Parents: <a href="sysreq.html#S70100">S70100</a></p><p>Children: <a href="c3ref/c_alter_table.html">H12550</a> <a href="c3ref/c_alter_table.html">H12551</a> <a href="c3ref/c_alter_table.html">H12552</a> <a href="c3ref/c_alter_table.html">H12553</a> <a href="c3ref/c_alter_table.html">H12554</a> <a href="c3ref/c_deny.html">H12590</a></p></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. <p>Parents: <a href="sysreq.html#S70100">S70100</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12502</td><td valign="top">The authorizer callback is invoked as SQL statements are
being parseed and compiled. <p>Parents: <a href="sysreq.html#S70100">S70100</a></p><p><i>No children</i></p></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. <p>Parents: <a href="sysreq.html#S70100">S70100</a></p><p><i>No children</i></p></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. <p>Parents: <a href="sysreq.html#S70100">S70100</a></p><p><i>No children</i></p></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. <p>Parents: <a href="sysreq.html#S70100">S70100</a></p><p><i>No children</i></p></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. <p>Parents: <a href="sysreq.html#S70100">S70100</a></p><p><i>No children</i></p></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>. <p>Parents: <a href="sysreq.html#S70100">S70100</a></p><p><i>No children</i></p></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. <p>Parents: <a href="sysreq.html#S70100">S70100</a></p><p><i>No children</i></p></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. <p>Parents: <a href="sysreq.html#S70100">S70100</a></p><p><i>No children</i></p></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. <p>Parents: <a href="sysreq.html#S70100">S70100</a></p><p><i>No children</i></p></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. <p>Parents: <a href="sysreq.html#S70100">S70100</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12521</td><td valign="top">A NULL authorizer means that no authorization
callback is invoked. <p>Parents: <a href="sysreq.html#S70100">S70100</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12522</td><td valign="top">The default authorizer is NULL. <p>Parents: <a href="sysreq.html#S70100">S70100</a></p><p><i>No children</i></p></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><p>Parents: <a href="c3ref/set_authorizer.html">H12500</a></p><p><i>No children</i></p></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. <p>Parents: <a href="c3ref/set_authorizer.html">H12500</a></p><p><i>No children</i></p></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. <p>Parents: <a href="c3ref/set_authorizer.html">H12500</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12553</td><td valign="top">The 5th parameter to the
<a href="c3ref/set_authorizer.html">authorizer callback</a> shall be the name
of the database (example: "main", "temp", etc.) if applicable. <p>Parents: <a href="c3ref/set_authorizer.html">H12500</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12554</td><td valign="top">The 6th parameter to the
<a href="c3ref/set_authorizer.html">authorizer callback</a> shall be the name
of the inner-most trigger or view that is responsible for
the access attempt or NULL if this access attempt is directly from
top-level SQL code. <p>Parents: <a href="c3ref/set_authorizer.html">H12500</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12590</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
#define SQLITE_DENY   1   /* Abort the SQL statement with an error */
#define SQLITE_IGNORE 2   /* Don't allow access, but don't generate an error */

</pre></blockquote><p>Parents: <a href="c3ref/set_authorizer.html">H12500</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12600</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_load_extension(
  sqlite3 *db,          /* Load the extension into this database connection */
  const char *zFile,    /* Name of the shared library containing extension */
  const char *zProc,    /* Entry point.  Derived from zFile if 0 */
  char **pzErrMsg       /* Put error message here if not 0 */
);

</pre></blockquote><p>Parents: <a href="sysreq.html#S20500">S20500</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12620</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_enable_load_extension(sqlite3 *db, int onoff);

</pre></blockquote><p>Parents: <a href="sysreq.html#S20500">S20500</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12640</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_auto_extension(void *xEntryPoint);

</pre></blockquote><p>Parents: <a href="sysreq.html#S20500">S20500</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12660</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
void sqlite3_reset_auto_extension(void);

</pre></blockquote><p>Parents: <a href="sysreq.html#S20500">S20500</a></p><p><i>No children</i></p></td></tr><tr><td valign="top">H12700</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_open(
  const char *filename,   /* Database filename (UTF-8) */
  sqlite3 **ppDb          /* OUT: SQLite db handle */
);
int sqlite3_open16(
  const void *filename,   /* Database filename (UTF-16) */
  sqlite3 **ppDb          /* OUT: SQLite db handle */
);