.Dd January 24, 2024
.Dt SQLITE3_GET_AUTOCOMMIT 3
.Os
.Sh NAME
.Nm sqlite3_get_autocommit
.Nd test for auto-Commit mode
.Sh SYNOPSIS
.In sqlite3.h
.Ft int
.Fo sqlite3_get_autocommit
.Fa "sqlite3*"
.Fc
.Sh DESCRIPTION
The sqlite3_get_autocommit() interface returns non-zero or zero if
the given database connection is or is not in autocommit mode, respectively.
Autocommit mode is on by default.
Autocommit mode is disabled by a BEGIN statement.
Autocommit mode is re-enabled by a COMMIT or ROLLBACK.
.Pp
If certain kinds of errors occur on a statement within a multi-statement
transaction (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 whether SQLite automatically rolled back the
transaction after an error is to use this function.
.Pp
If another thread changes the autocommit status of the database connection
while this routine is running, then the return value is undefined.
.Sh IMPLEMENTATION NOTES
These declarations were extracted from the
interface documentation at line 6554.
.Bd -literal
SQLITE_API int sqlite3_get_autocommit(sqlite3*);
.Ed
.Sh SEE ALSO
.Xr SQLITE_OK 3