hlreq.html

sqlite的帮助文档

<a href="c3ref/set_authorizer.html">authorizer callback</a> shall be the name
of the database (example: "main", "temp", etc.) if applicable. </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. </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></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></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></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></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></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 */
);
int sqlite3_open_v2(
  const char *filename,   /* Database filename (UTF-8) */
  sqlite3 **ppDb,         /* OUT: SQLite db handle */
  int flags,              /* Flags */
  const char *zVfs        /* Name of VFS module to use */
);

</pre></blockquote></td></tr><tr><td valign="top">H12701</td><td valign="top">The <a href="c3ref/open.html">sqlite3_open()</a>, <a href="c3ref/open.html">sqlite3_open16()</a>, and
<a href="c3ref/open.html">sqlite3_open_v2()</a> interfaces create a new
<a href="c3ref/sqlite3.html">database connection</a> associated with
the database file given in their first parameter. </td></tr><tr><td valign="top">H12702</td><td valign="top">The filename argument is interpreted as UTF-8
for <a href="c3ref/open.html">sqlite3_open()</a> and <a href="c3ref/open.html">sqlite3_open_v2()</a> and as UTF-16
in the native byte order for <a href="c3ref/open.html">sqlite3_open16()</a>. </td></tr><tr><td valign="top">H12703</td><td valign="top">A successful invocation of <a href="c3ref/open.html">sqlite3_open()</a>, <a href="c3ref/open.html">sqlite3_open16()</a>,
or <a href="c3ref/open.html">sqlite3_open_v2()</a> writes a pointer to a new
<a href="c3ref/sqlite3.html">database connection</a> into *ppDb. </td></tr><tr><td valign="top">H12704</td><td valign="top">The <a href="c3ref/open.html">sqlite3_open()</a>, <a href="c3ref/open.html">sqlite3_open16()</a>, and
<a href="c3ref/open.html">sqlite3_open_v2()</a> interfaces return <a href="c3ref/c_abort.html">SQLITE_OK</a> upon success,
or an appropriate <a href="c3ref/c_abort.html">error code</a> on failure. </td></tr><tr><td valign="top">H12706</td><td valign="top">The default text encoding for a new database created using
<a href="c3ref/open.html">sqlite3_open()</a> or <a href="c3ref/open.html">sqlite3_open_v2()</a> will be UTF-8. </td></tr><tr><td valign="top">H12707</td><td valign="top">The default text encoding for a new database created using
<a href="c3ref/open.html">sqlite3_open16()</a> will be UTF-16. </td></tr><tr><td valign="top">H12709</td><td valign="top">The <a href="c3ref/open.html">sqlite3_open(F,D)</a> interface is equivalent to
<a href="c3ref/open.html">sqlite3_open_v2(F,D,G,0)</a> where the G parameter is
<a href="c3ref/c_open_create.html">SQLITE_OPEN_READWRITE</a>|<a href="c3ref/c_open_create.html">SQLITE_OPEN_CREATE</a>. </td></tr><tr><td valign="top">H12711</td><td valign="top">If the G parameter to <a href="c3ref/open.html">sqlite3_open_v2(F,D,G,V)</a> contains the
bit value <a href="c3ref/c_open_create.html">SQLITE_OPEN_READONLY</a> then the database is opened
for reading only. </td></tr><tr><td valign="top">H12712</td><td valign="top">If the G parameter to <a href="c3ref/open.html">sqlite3_open_v2(F,D,G,V)</a> contains the
bit value <a href="c3ref/c_open_create.html">SQLITE_OPEN_READWRITE</a> then the database is opened
reading and writing if possible, or for reading only if the
file is write protected by the operating system. </td></tr><tr><td valign="top">H12713</td><td valign="top">If the G parameter to <a href="c3ref/open.html">sqlite3_open_v2(F,D,G,V)</a> omits the
bit value <a href="c3ref/c_open_create.html">SQLITE_OPEN_CREATE</a> and the database does not
previously exist, an error is returned. </td></tr><tr><td valign="top">H12714</td><td valign="top">If the G parameter to <a href="c3ref/open.html">sqlite3_open_v2(F,D,G,V)</a> contains the
bit value <a href="c3ref/c_open_create.html">SQLITE_OPEN_CREATE</a> and the database does not
previously exist, then an attempt is made to create and
initialize the database. </td></tr><tr><td valign="top">H12717</td><td valign="top">If the filename argument to <a href="c3ref/open.html">sqlite3_open()</a>, <a href="c3ref/open.html">sqlite3_open16()</a>,
or <a href="c3ref/open.html">sqlite3_open_v2()</a> is ":memory:", then an private,
ephemeral, in-memory database is created for the connection.
<todo>Is SQLITE_OPEN_CREATE|SQLITE_OPEN_READWRITE required
in sqlite3_open_v2()?</todo> </td></tr><tr><td valign="top">H12719</td><td valign="top">If the filename is NULL or an empty string, then a private,
ephemeral on-disk database will be created.
<todo>Is SQLITE_OPEN_CREATE|SQLITE_OPEN_READWRITE required
in sqlite3_open_v2()?</todo> </td></tr><tr><td valign="top">H12721</td><td valign="top">The <a href="c3ref/sqlite3.html">database connection</a> created by <a href="c3ref/open.html">sqlite3_open_v2(F,D,G,V)</a>
will use the <a href="c3ref/vfs.html">sqlite3_vfs</a> object identified by the V parameter,
or the default <a href="c3ref/vfs.html">sqlite3_vfs</a> object if V is a NULL pointer. </td></tr><tr><td valign="top">H12723</td><td valign="top">Two <a href="c3ref/sqlite3.html">database connections</a> will share a common cache if both were
opened with the same VFS while <a href="c3ref/enable_shared_cache.html">shared cache mode</a> was enabled and
if both filenames compare equal using memcmp() after having been
processed by the <a href="c3ref/vfs.html">xFullPathname</a> method of the VFS. </td></tr><tr><td valign="top">H12760</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_limit(sqlite3*, int id, int newVal);

</pre></blockquote></td></tr><tr><td valign="top">H12762</td><td valign="top">A successful call to <a href="c3ref/limit.html">sqlite3_limit(D,C,V)</a> where V is
positive changes the limit on the size of construct C in the
<a href="c3ref/sqlite3.html">database connection</a> D to the lesser of V and the hard upper
bound on the size of C that is set at compile-time. </td></tr><tr><td valign="top">H12766</td><td valign="top">A successful call to <a href="c3ref/limit.html">sqlite3_limit(D,C,V)</a> where V is negative
leaves the state of the <a href="c3ref/sqlite3.html">database connection</a> D unchanged. </td></tr><tr><td valign="top">H12769</td><td valign="top">A successful call to <a href="c3ref/limit.html">sqlite3_limit(D,C,V)</a> returns the
value of the limit on the size of construct C in the
<a href="c3ref/sqlite3.html">database connection</a> D as it was prior to the call. </td></tr><tr><td valign="top">H12790</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
#define SQLITE_LIMIT_LENGTH                    0
#define SQLITE_LIMIT_SQL_LENGTH                1
#define SQLITE_LIMIT_COLUMN                    2
#define SQLITE_LIMIT_EXPR_DEPTH                3
#define SQLITE_LIMIT_COMPOUND_SELECT           4
#define SQLITE_LIMIT_VDBE_OP                   5
#define SQLITE_LIMIT_FUNCTION_ARG              6
#define SQLITE_LIMIT_ATTACHED                  7
#define SQLITE_LIMIT_LIKE_PATTERN_LENGTH       8
#define SQLITE_LIMIT_VARIABLE_NUMBER           9

</pre></blockquote></td></tr><tr><td valign="top">H12800</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_errcode(sqlite3 *db);
int sqlite3_extended_errcode(sqlite3 *db);
const char *sqlite3_errmsg(sqlite3*);
const void *sqlite3_errmsg16(sqlite3*);

</pre></blockquote></td></tr><tr><td valign="top">H12801</td><td valign="top">The <a href="c3ref/errcode.html">sqlite3_errcode(D)</a> interface returns the numeric
<a href="c3ref/c_abort.html">result code</a> or <a href="c3ref/c_ioerr_access.html">extended result code</a> for the most recently
failed interface call associated with the <a href="c3ref/sqlite3.html">database connection</a> D. </td></tr><tr><td valign="top">H12802</td><td valign="top">The <a href="c3ref/errcode.html">sqlite3_extended_errcode(D)</a> interface returns the numeric
<a href="c3ref/c_ioerr_access.html">extended result code</a> for the most recently
failed interface call associated with the <a href="c3ref/sqlite3.html">database connection</a> D. </td></tr><tr><td valign="top">H12803</td><td valign="top">The <a href="c3ref/errcode.html">sqlite3_errmsg(D)</a> and <a href="c3ref/errcode.html">sqlite3_errmsg16(D)</a>
interfaces return English-language text that describes
the error in the mostly recently failed interface call,
encoded as either UTF-8 or UTF-16 respectively. </td></tr><tr><td valign="top">H12807</td><td valign="top">The strings returned by <a href="c3ref/errcode.html">sqlite3_errmsg()</a> and <a href="c3ref/errcode.html">sqlite3_errmsg16()</a>
are valid until the next SQLite interface call. </td></tr><tr><td valign="top">H12808</td><td valign="top">Calls to API routines that do not return an error code
(example: <a href="c3ref/data_count.html">sqlite3_data_count()</a>) do not
change the error code or message returned by
<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>, or <a href="c3ref/errcode.html">sqlite3_errmsg16()</a>. </td></tr><tr><td valign="top">H12809</td><td valign="top">Interfaces that are not associated with a specific
<a href="c3ref/sqlite3.html">database connection</a> (examples:
<a href="c3ref/mprintf.html">sqlite3_mprintf()</a> or <a href="c3ref/enable_shared_cache.html">sqlite3_enable_shared_cache()</a>
do not change the values returned by
<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>, or <a href="c3ref/errcode.html">sqlite3_errmsg16()</a>. </td></tr><tr><td valign="top">H12850</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_table_column_metadata(
  sqlite3 *db,                /* Connection handle */
  const char *zDbName,        /* Database name or NULL */
  const char *zTableName,     /* Table name */
  const char *zColumnName,    /* Column name */
  char const **pzDataType,    /* OUTPUT: Declared data type */
  char const **pzCollSeq,     /* OUTPUT: Collation sequence name */
  int *pNotNull,              /* OUTPUT: True if NOT NULL constraint exists */
  int *pPrimaryKey,           /* OUTPUT: True if column part of PK */
  int *pAutoinc               /* OUTPUT: True if column is auto-increment */
);

</pre></blockquote></td></tr><tr><td valign="top">H12910</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
void sqlite3_progress_handler(sqlite3*, int, int(*)(void*), void*);

</pre></blockquote></td></tr><tr><td valign="top">H12911</td><td valign="top">The callback function registered by sqlite3_progress_handler()
is invoked periodically during long running calls to
<a href="c3ref/step.html">sqlite3_step()</a>. </td></tr><tr><td valign="top">H12912</td><td valign="top">The progress callback is invoked once for every N virtual
machine opcodes, where N is the second argument to
the <a href="c3ref/progress_handler.html">sqlite3_progress_handler()</a> call that registered
the callback.  If N is less than 1, sqlite3_progress_handler()
acts as if a NULL progress handler had been specified. </td></tr><tr><td valign="top">H12913</td><td valign="top">The progress callback itself is identified by the third
argument to sqlite3_progress_handler(). </td></tr><tr><td valign="top">H12914</td><td valign="top">The fourth argument to sqlite3_progress_handler() is a
void pointer passed to the progress callback
function each time it is invoked. </td></tr><tr><td valign="top">H12915</td><td valign="top">If a call to <a href="c3ref/step.html">sqlite3_step()</a> results in fewer than N opcodes
being executed, then the progress callback is never invoked. </td></tr><tr><td valign="top">H12916</td><td valign="top">Every call to <a href="c3ref/progress_handler.html">sqlite3_progress_handler()</a>
overwrites any previously registered progress handler. </td></tr><tr><td valign="top">H12917</td><td valign="top">If the progress handler callback is NULL then no progress
handler is invoked. </td></tr><tr><td valign="top">H12918</td><td valign="top">If the progress callback returns a result other than 0, then
the behavior is a if <a href="c3ref/interrupt.html">sqlite3_interrupt()</a> had been called.
</td></tr><tr><td valign="top">H12930</td><td valign="top">The sqlite3.h header file shall define the
the following interfaces:
<blockquote><pre>
int sqlite3_get_autocommit(sqlite3*);

</pre></blockquote></td></tr><tr><td valign="top">H12931</td><td valign="top">The <a href="c3ref/get_autocommit.html">sqlite3_get_autocommit(D)</a> interface returns non-zero or
zero if the <a href="c3ref/sqlite3.html">database connection</a> D is or is not in autocommit
mode, respectively. </td></tr><tr><td valign="top">H12932</td><td valign="top">Autocommit mode is on by default. </td></tr><tr><td valign="top">H12933</td><td valign="top">Autocommit mode is disabled by a successful <a href="lang_transaction.html">BEGIN</a> statement. </td></tr><tr><td valign="to