requirements.html

这是sqlite3.56的文档。拿来给大家阅读使用

void pointer passed to the progress callback
function each time it is invoked.
</td></tr>
<tr><td valign="top">F12915</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. {END}
</td></tr>
<tr><td valign="top">F12916</td><td valign="top">
Every call to 
<a href="c3ref/progress_handler.html">sqlite3_progress_handler()</a>
overwrites any previously registere progress handler.
</td></tr>
<tr><td valign="top">F12917</td><td valign="top">
If the progress handler callback is NULL then no progress
handler is invoked.
</td></tr>
<tr><td valign="top">F12918</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">F12930</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
int sqlite3_get_autocommit(sqlite3*);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F12931</td><td valign="top">
The 
<a href="c3ref/get_autocommit.html">sqlite3_get_autocommit()</a> interface returns non-zero or
zero if the given database connection is or is not in autocommit
mode, respectively.
</td></tr>
<tr><td valign="top">F12932</td><td valign="top">
Autocommit mode is on by default.
</td></tr>
<tr><td valign="top">F12933</td><td valign="top">
Autocommit mode is disabled by a successful 
<a href="lang_transaction.html">BEGIN</a> statement.
</td></tr>
<tr><td valign="top">F12934</td><td valign="top">
Autocommit mode is enabled by a successful 
<a href="lang_transaction.html">COMMIT</a> or 
<a href="lang_transaction.html">ROLLBACK</a>
statement.
</td></tr>
<tr><td valign="top">F12950</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
void *sqlite3_commit_hook(sqlite3*, int(*)(void*), void*);
void *sqlite3_rollback_hook(sqlite3*, void(*)(void *), void*);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F12970</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
void *sqlite3_update_hook(
  sqlite3*, 
  void(*)(void *,int ,char const *,char const *,sqlite3_int64),
  void*
);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F13000</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
typedef struct sqlite3_stmt sqlite3_stmt;

</pre></blockquote>
</td></tr>
<tr><td valign="top">F13010</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
int sqlite3_prepare(
  sqlite3 *db,            /* Database handle */
  const char *zSql,       /* SQL statement, UTF-8 encoded */
  int nByte,              /* Maximum length of zSql in bytes. */
  sqlite3_stmt **ppStmt,  /* OUT: Statement handle */
  const char **pzTail     /* OUT: Pointer to unused portion of zSql */
);
int sqlite3_prepare_v2(
  sqlite3 *db,            /* Database handle */
  const char *zSql,       /* SQL statement, UTF-8 encoded */
  int nByte,              /* Maximum length of zSql in bytes. */
  sqlite3_stmt **ppStmt,  /* OUT: Statement handle */
  const char **pzTail     /* OUT: Pointer to unused portion of zSql */
);
int sqlite3_prepare16(
  sqlite3 *db,            /* Database handle */
  const void *zSql,       /* SQL statement, UTF-16 encoded */
  int nByte,              /* Maximum length of zSql in bytes. */
  sqlite3_stmt **ppStmt,  /* OUT: Statement handle */
  const void **pzTail     /* OUT: Pointer to unused portion of zSql */
);
int sqlite3_prepare16_v2(
  sqlite3 *db,            /* Database handle */
  const void *zSql,       /* SQL statement, UTF-16 encoded */
  int nByte,              /* Maximum length of zSql in bytes. */
  sqlite3_stmt **ppStmt,  /* OUT: Statement handle */
  const void **pzTail     /* OUT: Pointer to unused portion of zSql */
);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F13011</td><td valign="top">
The 
<a href="c3ref/prepare.html">sqlite3_prepare(db,zSql,...)</a> and

<a href="c3ref/prepare.html">sqlite3_prepare_v2(db,zSql,...)</a> interfaces interpret the
text in their zSql parameter as UTF-8.
</td></tr>
<tr><td valign="top">F13012</td><td valign="top">
The 
<a href="c3ref/prepare.html">sqlite3_prepare16(db,zSql,...)</a> and

<a href="c3ref/prepare.html">sqlite3_prepare16_v2(db,zSql,...)</a> interfaces interpret the
text in their zSql parameter as UTF-16 in the native byte order.
</td></tr>
<tr><td valign="top">F13013</td><td valign="top">
If the nByte argument to 
<a href="c3ref/prepare.html">sqlite3_prepare_v2(db,zSql,nByte,...)</a>
and its variants is less than zero, then SQL text is
read from zSql is read up to the first zero terminator.
</td></tr>
<tr><td valign="top">F13014</td><td valign="top">
If the nByte argument to 
<a href="c3ref/prepare.html">sqlite3_prepare_v2(db,zSql,nByte,...)</a>
and its variants is non-negative, then nBytes bytes
SQL text is read from zSql.
</td></tr>
<tr><td valign="top">F13015</td><td valign="top">
In 
<a href="c3ref/prepare.html">sqlite3_prepare_v2(db,zSql,N,P,pzTail)</a> and its variants
if the zSql input text contains more than one SQL statement
and pzTail is not NULL, then *pzTail is made to point to the
first byte past the end of the first SQL statement in zSql.
<todo>What does *pzTail point to if there is one statement?</todo>
</td></tr>
<tr><td valign="top">F13016</td><td valign="top">
A successful call to 
<a href="c3ref/prepare.html">sqlite3_prepare_v2(db,zSql,N,ppStmt,...)</a>
or one of its variants writes into *ppStmt a pointer to a new

<a href="c3ref/stmt.html">prepared statement</a> or a pointer to NULL
if zSql contains nothing other than whitespace or comments.
</td></tr>
<tr><td valign="top">F13019</td><td valign="top">
The 
<a href="c3ref/prepare.html">sqlite3_prepare_v2()</a> interface and its variants return

<a href="c3ref/c_abort.html">SQLITE_OK</a> or an appropriate 
<a href="c3ref/c_abort.html">error code</a> upon failure.
</td></tr>
<tr><td valign="top">F13120</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
sqlite3 *sqlite3_db_handle(sqlite3_stmt*);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F13200</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
int sqlite3_step(sqlite3_stmt*);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F13202</td><td valign="top">
If 
<a href="c3ref/stmt.html">prepared statement</a> S is ready to be
run, then 
<a href="c3ref/step.html">sqlite3_step(S)</a> advances that prepared statement
until to completion or until it is ready to return another
row of the result set or an interrupt or run-time error occurs.
</td></tr>
<tr><td valign="top">F13300</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
int sqlite3_finalize(sqlite3_stmt *pStmt);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F13330</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
int sqlite3_reset(sqlite3_stmt *pStmt);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F13500</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
int sqlite3_bind_blob(sqlite3_stmt*, int, const void*, int n, void(*)(void*));
int sqlite3_bind_double(sqlite3_stmt*, int, double);
int sqlite3_bind_int(sqlite3_stmt*, int, int);
int sqlite3_bind_int64(sqlite3_stmt*, int, sqlite3_int64);
int sqlite3_bind_null(sqlite3_stmt*, int);
int sqlite3_bind_text(sqlite3_stmt*, int, const char*, int n, void(*)(void*));
int sqlite3_bind_text16(sqlite3_stmt*, int, const void*, int, void(*)(void*));
int sqlite3_bind_value(sqlite3_stmt*, int, const sqlite3_value*);
int sqlite3_bind_zeroblob(sqlite3_stmt*, int, int n);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F13506</td><td valign="top">
The 
<a href="c3ref/prepare.html">SQL statement compiler</a> recognizes
tokens of the forms "?", "?NNN", "$VVV", ":VVV", and "@VVV"
as SQL parameters, where NNN is any sequence of one or more
digits and where VVV is any sequence of one or more
alphanumeric characters or "::" optionally followed by
a string containing no spaces and contained within parentheses.
</td></tr>
<tr><td valign="top">F13509</td><td valign="top">
The initial value of an SQL parameter is NULL.
</td></tr>
<tr><td valign="top">F13512</td><td valign="top">
The index of an "?" SQL parameter is one larger than the
largest index of SQL parameter to the left, or 1 if
the "?" is the leftmost SQL parameter.
</td></tr>
<tr><td valign="top">F13515</td><td valign="top">
The index of an "?NNN" SQL parameter is the integer NNN.
</td></tr>
<tr><td valign="top">F13518</td><td valign="top">
The index of an ":VVV", "$VVV", or "@VVV" SQL parameter is
the same as the index of leftmost occurances of the same
parameter, or one more than the largest index over all
parameters to the left if this is the first occurrance
of this parameter, or 1 if this is the leftmost parameter.
</td></tr>
<tr><td valign="top">F13521</td><td valign="top">
The 
<a href="c3ref/prepare.html">SQL statement compiler</a> fail with
an 
<a href="c3ref/c_abort.html">SQLITE_RANGE</a> error if the index of an SQL parameter
is less than 1 or greater than SQLITE_MAX_VARIABLE_NUMBER.
</td></tr>
<tr><td valign="top">F13524</td><td valign="top">
Calls to 
<a href="c3ref/bind_blob.html">sqlite3_bind(S,N,V,...)</a>
associate the value V with all SQL parameters having an
index of N in the 
<a href="c3ref/stmt.html">prepared statement</a> S.
</td></tr>
<tr><td valign="top">F13527</td><td valign="top">
Calls to 
<a href="c3ref/bind_blob.html">sqlite3_bind(S,N,...)</a>
override prior calls with the same values of S and N.
</td></tr>
<tr><td valign="top">F13530</td><td valign="top">
Bindings established by 
<a href="c3ref/bind_blob.html">sqlite3_bind(S,...)</a>
persist across calls to 
<a href="c3ref/reset.html">sqlite3_reset(S)</a>.
</td></tr>
<tr><td valign="top">F13533</td><td valign="top">
In calls to 
<a href="c3ref/bind_blob.html">sqlite3_bind_blob(S,N,V,L,D)</a>,

<a href="c3ref/bind_blob.html">sqlite3_bind_text(S,N,V,L,D)</a>, or

<a href="c3ref/bind_blob.html">sqlite3_bind_text16(S,N,V,L,D)</a> SQLite binds the first L
bytes of the blob or string pointed to by V, when L
is non-negative.
</td></tr>
<tr><td valign="top">F13536</td><td valign="top">
In calls to 
<a href="c3ref/bind_blob.html">sqlite3_bind_text(S,N,V,L,D)</a> or

<a href="c3ref/bind_blob.html">sqlite3_bind_text16(S,N,V,L,D)</a> SQLite binds characters
from V through the first zero character when L is negative.
</td></tr>
<tr><td valign="top">F13539</td><td valign="top">
In calls to 
<a href="c3ref/bind_blob.html">sqlite3_bind_blob(S,N,V,L,D)</a>,

<a href="c3ref/bind_blob.html">sqlite3_bind_text(S,N,V,L,D)</a>, or

<a href="c3ref/bind_blob.html">sqlite3_bind_text16(S,N,V,L,D)</a> when D is the special
constant 
<a href="c3ref/c_static.html">SQLITE_STATIC</a>, SQLite assumes that the value V
is held in static unmanaged space that will not change
during the lifetime of the binding.
</td></tr>
<tr><td valign="top">F13542</td><td valign="top">
In calls to 
<a href="c3ref/bind_blob.html">sqlite3_bind_blob(S,N,V,L,D)</a>,

<a href="c3ref/bind_blob.html">sqlite3_bind_text(S,N,V,L,D)</a>, or

<a href="c3ref/bind_blob.html">sqlite3_bind_text16(S,N,V,L,D)</a> when D is the special
constant 
<a href="c3ref/c_static.html">SQLITE_TRANSIENT</a>, the routine makes a
private copy of V value before it returns.
</td></tr>
<tr><td valign="top">F13545</td><td valign="top">
In calls to 
<a href="c3ref/bind_blob.html">sqlite3_bind_blob(S,N,V,L,D)</a>,

<a href="c3ref/bind_blob.html">sqlite3_bind_text(S,N,V,L,D)</a>, or

<a href="c3ref/bind_blob.html">sqlite3_bind_text16(S,N,V,L,D)</a> when D is a pointer to
a function, SQLite invokes that function to destroy the
V value after it has finished using the V value.
</td></tr>
<tr><td valign="top">F13548</td><td valign="top">
In calls to 
<a href="c3ref/bind_blob.html">sqlite3_bind_zeroblob(S,N,V,L)</a> the value bound
is a blob of L bytes, or a zero-length blob if L is negative.
</td></tr>
<tr><td valign="top">F13600</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
int sqlite3_bind_parameter_count(sqlite3_stmt*);

</pre></blockquote>
</td></tr>
<tr><td valign="top">F13601</td><td valign="top">
The 
<a href="c3ref/bind_parameter_count.html">sqlite3_bind_parameter_count(S)</a> interface returns
the largest index of all SQL parameters in the

<a href="c3ref/stmt.html">prepared statement</a> S, or 0 if S
contains no SQL parameters.
</td></tr>
<tr><td valign="top">F13620</td><td valign="top">
The sqlite3.h header file defines the following interfaces:
<blockquote><pre>
const char *sqlite3_bind_parameter_name(sqlite3_stmt*, int);

</pre>