Small, Fast, Reliable.
Choose any three.

SQLite C Interface

Test To See If The Database Is In Auto-Commit Mode

int sqlite3_get_autocommit(sqlite3*);

Test to see whether or not the database connection is in autocommit mode. Return TRUE if it is and FALSE if not. Autocommit mode is on by default. Autocommit is disabled by a BEGIN statement and reenabled by the next COMMIT or ROLLBACK.

If certain kinds of errors occur on a statement within a multi-statement transactions (errors including SQLITE_FULL, SQLITE_IOERR, SQLITE_NOMEM, SQLITE_BUSY, and SQLITE_INTERRUPT) then the transaction might be rolled back automatically. The only way to find out if SQLite automatically rolled back the transaction after an error is to use this function.

If another thread changes the autocommit status of the database connection while this routine is running, then the return value is undefined.

See also lists of Objects, Constants, and Functions.


This page last modified 2007/11/22 00:41:31 UTC