| ErrorCode Enumeration |
SQLite Result and Error Codes
Namespace: SQLitePCL.pretty
Assembly: SQLitePCL.pretty (in SQLitePCL.pretty.dll) Version: 1.0.0.0 (1.0.0)
SyntaxMembers| Member name | Value | Description | |
|---|---|---|---|
| Ok | 0 | The operation was successful and that there were no errors. Most other result codes indicate an error. | |
| Error | 1 | Generic error code that is used when no other more specific error code is available. | |
| Internal | 2 | Indicates an internal malfunction. | |
| Perm | 3 | Indicates that the requested access mode for a newly created database could not be provided. | |
| Abort | 4 | Indicates that an operation was aborted prior to completion, usually be application request. | |
| Busy | 5 | Indicates that the database file could not be written (or in some cases read) because of concurrent activity by some other database connection, usually a database connection in a separate process. | |
| Locked | 6 | Indicates that a write operation could not continue because of a conflict within the same database connection or a conflict with a different database connection that uses a shared cache. | |
| NoMemory | 7 | Indicates that SQLite was unable to allocate all the memory it needed to complete the operation. | |
| ReadOnly | 8 | An attempt was made to alter some data for which the current database connection does not have write permission. | |
| Interrupt | 9 | Indicates that an operation was interrupted. | |
| IOError | 10 | The operation could not finish because the operating system reported an I/O error. | |
| Corrupt | 11 | Indicates that the database file has been corrupted. | |
| NotFound | 12 | ||
| Full | 13 | Indicates that a write could not complete because the disk is full. | |
| CannotOpen | 14 | Indicates that SQLite was unable to open a file. | |
| Protocol | 15 | Indicates a problem with the file locking protocol used by SQLite. | |
| Empty | 16 | Result code is not currently used. | |
| Schema | 17 | Indicates that the database schema has changed. | |
| TooBig | 18 | Indicates that a string or BLOB was too large. | |
| Constraint | 19 | Indicates that an SQL constraint violation occurred while trying to process an SQL statement. | |
| Mismatch | 20 | Indicates a datatype mismatch. | |
| Misuse | 21 | Returned if the application uses any SQLite interface in a way that is undefined or unsupported. | |
| NoLFS | 22 | Returned on systems that do not support large files when the database grows to be larger than what the filesystem can handle. | |
| NotAuthorized | 23 | Returned when the authorizer callback indicates that an SQL statement being prepared is not authorized. | |
| Format | 24 | Error code is not currently used by SQLite. | |
| Range | 25 | Indicates that the parameter number argument to one of the sqlite3_bind routines is out of range. | |
| NotDatabase | 26 | Indicates that the file being opened does not appear to be an SQLite database file. | |
| Notice | 27 | ||
| Warning | 28 | ||
| Row | 100 | Indicates that another row of output is available. | |
| Done | 101 | Indicates that an operation has completed. | |
| IOErrorRead | 266 | Indicates an I/O error in the VFS layer while trying to read from a file on disk. | |
| IOErrorShortRead | 522 | Indicates that a read attempt in the VFS layer was unable to obtain as many bytes as was requested. | |
| IOErrorWrite | 778 | Indicates an I/O error in the VFS layer while trying to write into a file on disk. | |
| IOErrorFSync | 1034 | Indicates an I/O error in the VFS layer while trying to flush previously written content out of OS and/or disk-control buffers and into persistent storage. | |
| IOErrorDirFSync | 1290 | Indicates an I/O error in the VFS layer while trying to invoke fsync() on a directory. | |
| IOErrorTruncate | 1546 | Indicates an I/O error in the VFS layer while trying to truncate a file to a smaller size. | |
| IOErrorFStat | 1802 | Indicates an I/O error in the VFS layer while trying to invoke fstat() (or the equivalent) on a file in order to determine information such as the file size or access permissions. | |
| IOErrorUnlock | 2058 | Indicates an I/O error within xUnlock method on the sqlite3_io_methods object. | |
| IOErrorReadLock | 2314 | Indicates an I/O error within xLock method on the sqlite3_io_methods object while trying to obtain a read lock. | |
| IOErrorDelete | 2570 | Indicates an I/O error within xDelete method on the sqlite3_vfs object. | |
| IOErrorBlocked | 2826 | Error code is no longer used. | |
| IOErrorNoMemory | 3082 | Indicates that an operation could not be completed due to the inability to allocate sufficient memory. | |
| IOErrorAccess | 3338 | iIndicates an I/O error within the xAccess method on the sqlite3_vfs object. | |
| IOErrorCheckReservedLock | 3594 | Indicates an I/O error within the xCheckReservedLock method on the sqlite3_io_methods object. | |
| IOErrorLock | 3850 | Indicates an I/O error in the advisory file locking logic. | |
| IOErrorClose | 4106 | Indicates an I/O error within the xClose method on the sqlite3_io_methods object. | |
| IOErrorDirClose | 4362 | Error code is no longer used. | |
| IOErrorShmOpen | 4618 | Indicates an I/O error within the xShmMap method on the sqlite3_io_methods object while trying to open a new shared memory segment. | |
| IOErrorShmSize | 4874 | Indicates an I/O error within the xShmMap method on the sqlite3_io_methods object while trying to resize an existing shared memory segment. | |
| IOErrorShmLock | 5130 | Error code is no longer used. | |
| IOErrorShmMap | 5386 | Indicating an I/O error within the xShmMap method on the sqlite3_io_methods object while trying to map a shared memory segment into the process address space. | |
| IOErrorSeek | 5642 | Indicates an I/O error within the xRead or xWrite methods on the sqlite3_io_methods object while trying to seek a file descriptor to the beginning point of the file where the read or write is to occur. | |
| IOErrorDeleteNoEnt | 5898 | Indicates that the xDelete method on the sqlite3_vfs object failed because the file being deleted does not exist. | |
| IOErrorMMap | 6154 | Indicates an I/O error within the xFetch or xUnfetch methods on the sqlite3_io_methods object while trying to map or unmap part of the database file into the process address space. | |
| IOErrorGetTempPath | 6410 | Indicates that the VFS is unable to determine a suitable directory in which to place temporary files. | |
| IOErrorConvPath | 6666 | Used only by Cygwin VFS to indicate that the cygwin_conv_path() system call failed. | |
| LockSharedCache | 262 | Indicates that a locking conflict has occurred due to contention with a different database connection that happens to hold a shared cache with the database connection to which the error was returned. | |
| BusyRecovery | 261 | ||
| BusySnapShot | 517 | Occurs on WAL mode databases when a database connection tries to promote a read transaction into a write transaction but finds that another database connection has already written to the database and thus invalidated prior reads. | |
| CannotOpenNoTempDirectory | 270 | Error code is no longer used. | |
| CannotOpenIsDirectory | 526 | Indicates that a file open operation failed because the file is really a directory. | |
| CannotOpenFullPath | 782 | Indicates that a file open operation failed because the operating system was unable to convert the filename into a full pathname. | |
| CannotOpenConvPath | 1038 | Used only by Cygwin VFS and indicating that the cygwin_conv_path() system call failed while trying to open a file. | |
| CorruptVTab | 267 | Indicates that content in the virtual table is corrupt. | |
| ReadonlyRecovery | 264 | Indicates that a WAL mode database cannot be opened because the database file needs to be recovered and recovery requires write access but only read access is available. | |
| ReadonlyCannotLock | 520 | Indicates that SQLite is unable to obtain a read lock on a WAL mode database because the shared-memory file associated with that database is read-only. | |
| ReadonlyRollback | 776 | Indicates that a database cannot be opened because it has a hot journal that needs to be rolled back but cannot because the database is readonly. | |
| ReadonlyDatabaseMoved | 1032 | Indicates that a database cannot be modified because the database file has been moved since it was opened, and so any attempt to modify the database might result in database corruption if the processes crashes because the rollback journal would not be correctly named. | |
| AbortRollback | 516 | Indicates that an SQL statement aborted because the transaction that was active when the SQL statement first started was rolled back. | |
| ConstraintCheck | 275 | Indicates that a CHECK constraint failed | |
| ConstraintCommitHook | 531 | Indicates that a commit hook callback returned true, thus causing the SQL statement to be rolled back. | |
| ConstraintForeignKey | 787 | Indicates that a foreign key constraint failed. | |
| ConstraintFunction | 1043 | Not currently used by the SQLite core. | |
| ConstraintNotNull | 1299 | Indicates that a NOT NULL constraint failed. | |
| ConstraintPrimaryKey | 1555 | Indicates that a PRIMARY KEY constraint failed. | |
| ConstraintTrigger | 1811 | Indicates that a RAISE function within a trigger fired, causing the SQL statement to abort | |
| ConstraintUnique | 2067 | Indicates that a UNIQUE constraint failed. | |
| ConstraintVTab | 2323 | Not currently used by the SQLite core. | |
| ConstraintRowId | 2579 | Indicates that a rowid is not unique. | |
| NoticeRecoverWal | 283 | ||
| NoticeRecoverRollback | 539 | ||
| WarningAutoIndex | 284 |
See Also