The following table lists the result code constants. Note that these result code constants also contain what the SQLite documentation referes to as the extended result codes. ooSQLite has the extended result codes enabled at compile time, so there is no distinction between the result codes and the extended result codes:
Constant | Meaning |
OK | Successful result |
ERROR | SQL error or missing database |
INTERNAL | Internal logic error in SQLite |
PERM | Access permission denied |
ABORT | Callback routine requested an abort |
BUSY | The database file is locked |
LOCKED | A table in the database is locked |
NOMEM | A malloc() failed |
READONLY | Attempt to write a readonly database |
INTERRUPT | Operation terminated by sqlite3_interrupt() |
IOERR | Some kind of disk I/O error occurred |
CORRUPT | The database disk image is malformed |
NOTFOUND | Unknown opcode in sqlite3_file_control() |
FULL | Insertion failed because database is full |
CANTOPEN | Unable to open the database file |
PROTOCOL | Database lock protocol error |
EMPTY | Database is empty |
SCHEMA | The database schema changed |
TOOBIG | String or BLOB exceeds size limit |
CONSTRAINT | Abort due to constraint violation |
MISMATCH | Data type mismatch |
MISUSE | Library used incorrectly |
NOLFS | Uses OS features not supported on host |
AUTH | Authorization denied |
FORMAT | Auxiliary database format error |
RANGE | 2nd parameter to sqlite3_bind out of range |
NOTADB | File opened that is not a database file |
NOTICE | Notifications from sqlite3_log() |
WARNING | Warnings from sqlite3_log() |
ROW | sqlite3_step() has another row ready |
DONE | sqlite3_step() has finished executing |
IOERR_READ | |
IOERR_SHORT_READ | |
IOERR_WRITE | |
IOERR_FSYNC | |
IOERR_DIR_FSYNC | |
IOERR_TRUNCATE | |
IOERR_FSTAT | |
IOERR_UNLOCK | |
IOERR_RDLOCK | |
IOERR_DELETE | |
IOERR_BLOCKED | |
IOERR_NOMEM | |
IOERR_ACCESS | |
IOERR_CHECKRESERVEDLOCK | |
IOERR_LOCK | |
IOERR_CLOSE | |
IOERR_DIR_CLOSE | |
IOERR_SHMOPEN | |
IOERR_SHMSIZE | |
IOERR_SHMLOCK | |
IOERR_SHMMAP | |
IOERR_SEEK | |
IOERR_DELETE_NOENT | |
IOERR_MMAP | |
IOERR_GETTEMPPATH | |
IOERR_CONVPATH | |
LOCKED_SHAREDCACHE | |
BUSY_RECOVERY | |
BUSY_SNAPSHOT | |
CANTOPEN_NOTEMPDIR | |
CANTOPEN_ISDIR | |
CANTOPEN_FULLPATH | |
CANTOPEN_CONVPATH | |
CORRUPT_VTAB | |
READONLY_RECOVERY | |
READONLY_CANTLOCK | |
READONLY_ROLLBACK | |
READONLY_DBMOVED | |
ABORT_ROLLBACK | |
CONSTRAINT_CHECK | |
CONSTRAINT_COMMITHOOK | |
CONSTRAINT_FOREIGNKEY | |
CONSTRAINT_FUNCTION | |
CONSTRAINT_NOTNULL | |
CONSTRAINT_PRIMARYKEY | |
CONSTRAINT_TRIGGER | |
CONSTRAINT_UNIQUE | |
CONSTRAINT_VTAB | |
NOTICE_RECOVER_WAL | |
NOTICE_RECOVER_ROLLBACK | |
WARNING_AUTOINDEX |