C API: Database Connection Configuration Options
(c3ref/c_dbconfig_defensive.html)
SQLITE_DBCONFIG_MAINDBNAME, SQLITE_DBCONFIG_LOOKASIDE, SQLITE_DBCONFIG_ENABLE_FKEY, SQLITE_DBCONFIG_ENABLE_TRIGGER, SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER, SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION ...
... sqlite3_db_config(db, SQLITE_DBCONFIG_RESET_DATABASE, 1, 0);
sqlite3_exec(db, "VACUUM", 0, 0, 0);
sqlite3_db_config(db, SQLITE_DBCONFIG_RESET_DATABASE, 0, 0);
Because resetting a database is destructive and irreversible, the
process requires the use of this obscure API and multiple steps to
help ensure that ...
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... If the callback function to sqlite3_exec() returns non-zero, then
sqlite3_exec() will return SQLITE_ABORT.
If a ROLLBACK operation occurs on the same database connection as
a pending read or write, then the pending read or write may fail with
an ...
|
The Session Extension
(sessionintro.html)
3.1. Capturing a Changeset
... changes to all tables */
if( rc==SQLITE_OK ) rc = sqlite3session_attach(pSession, NULL);
/* Execute the SQL script */
if( rc==SQLITE_OK ) rc = sqlite3_exec(db, zSql, 0, 0, 0);
/* Collect the changeset */
if( rc==SQLITE_OK ){
rc = sqlite3session_changeset(pSession, pnChangeset, ppChangeset);
}
/* Delete the session object ...
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA empty_result_callbacks
... The empty-result-callbacks flag affects the sqlite3_exec() API only.
Normally, when the empty-result-callbacks flag is cleared, the
callback function supplied to the sqlite3_exec() is not invoked
for commands that return zero rows of data. When empty-result ...
|
SQLite Frequently Asked Questions
(faq.html)
... You will never receive an SQLITE_SCHEMA error from
sqlite3_exec(). Nor will you receive an error if you
prepare statements using sqlite3_prepare_v2() instead of
sqlite3_prepare().
The sqlite3_prepare_v2() interface creates a
prepared statement that will automatically recompile itself if
the schema changes ...
|
SQLite Older News
(oldnews.html)
... Because
sqlite3_exec() uses sqlite3_prepare() internally, the problem also affects
sqlite3_exec().
Upgrading from 3.7.7 is only required for applications that use "PRAGMA
case_sensitive_like" and the sqlite3_prepare() (or sqlite3_exec()) interface.
2011-06-24 - Version 3.7.7
SQLite version 3 ...
|
Command Line Shell For SQLite
(cli.html)
4.3. Dot-command execution
The dot-commands
are interpreted by the sqlite3.exe command-line program, not by
SQLite itself. So none of the dot-commands will work as an argument
to SQLite interfaces such as sqlite3_prepare() or sqlite3_exec().
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... P1 is the result code returned by sqlite3_exec(), sqlite3_reset(),
or sqlite3_finalize(). For a normal halt, this should be SQLITE_OK (0).
For errors, it can be some other value. If P1!=0 then P2 will determine
whether or not to rollback ...
|
Page generated by FTS5 in about 18.78 ms.