Small. Fast. Reliable.
Choose any three.

SQLite C Interface

Extended Result Codes

#define SQLITE_IOERR_READ          (SQLITE_IOERR | (1<<8))
#define SQLITE_IOERR_WRITE         (SQLITE_IOERR | (3<<8))
#define SQLITE_IOERR_FSYNC         (SQLITE_IOERR | (4<<8))
#define SQLITE_IOERR_FSTAT         (SQLITE_IOERR | (7<<8))
#define SQLITE_IOERR_UNLOCK        (SQLITE_IOERR | (8<<8))
#define SQLITE_IOERR_RDLOCK        (SQLITE_IOERR | (9<<8))
#define SQLITE_IOERR_DELETE        (SQLITE_IOERR | (10<<8))
#define SQLITE_IOERR_BLOCKED       (SQLITE_IOERR | (11<<8))
#define SQLITE_IOERR_NOMEM         (SQLITE_IOERR | (12<<8))

In its default configuration, SQLite API routines return one of 26 integer result codes. However, experience has shown that many of these result codes are too course-grained. They do not provide as much information about problems as programmers might like. In an effort to address this, newer versions of SQLite (version 3.3.8 and later) include support for additional result codes that provide more detailed information about errors. The extended result codes are enabled or disabled for each database connection using the sqlite3_extended_result_codes() API.

Some of the available extended result codes are listed here. One may expect the number of extended result codes will be expand over time. Software that uses extended result codes should expect to see new result codes in future releases of SQLite.

The SQLITE_OK result code will never be extended. It will always be exactly zero.


F10223 The symbolic name for an extended result code always contains a related primary result code as a prefix.
F10224 Primary result code names contain a single "_" character.
F10225 Extended result code names contain two or more "_" characters.
F10226 The numeric value of an extended result code contains the numeric value of its corresponding primary result code in its least significant 8 bits.

See also lists of Objects, Constants, and Functions.

This page last modified 2008/05/12 13:08:44 UTC