Troubleshooting SQLite Result Codes from Error 1299 to 1811

SQLServerF1

SQL return code 1299 SQLITE_CONSTRAINT_NOTNULL
The SQLITE_CONSTRAINT_NOTNULL error code is an extended error code for SQLITE_CONSTRAINT indicating that a NOT NULL constraint failed.
SQL return code 1546 SQLITE_IOERR_TRUNCATE

The SQLITE_IOERR_TRUNCATE error code is an extended error code for SQLITE_IOERR indicating an I/O error in the VFS layer while trying to truncate a file to a smaller size.
SQL return code 1555 SQLITE_CONSTRAINT_PRIMARYKEY
The SQLITE_CONSTRAINT_PRIMARYKEY error code is an extended error code for SQLITE_CONSTRAINT indicating that a PRIMARY KEY constraint failed.
SQL return code 1802 SQLITE_IOERR_FSTAT

The SQLITE_IOERR_FSTAT error code is an extended error code for SQLITE_IOERR indicating 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.
SQL return code 1811 SQLITE_CONSTRAINT_TRIGGER
The SQLITE_CONSTRAINT_TRIGGER error code is an extended error code for SQLITE_CONSTRAINT indicating that a RAISE function within a trigger fired, causing the SQL statement to abort.

Above are the list of SQLite Result Codes or Error Codes and their Description from Error 1299 to 1811 while performing certain operations against SQLite.

What are SQLite Errors?

SQLite programs have access to several types of common error information when the server returns an error. The SQLite message displayed contains three types of information:

A numeric error code. This number is SQLite and is not portable to other database systems. All result codes are integers. Symbolic names for all result codes are created using “#define” macros.Primary result code symbolic names are of the form “SQLITE_XXXXXX” where XXXXXX is a sequence of uppercase alphabetic characters. Extended result code names are of the form “SQLITE_XXXXXX_YYYYYYY” where the XXXXXX part is the corresponding primary result code and the YYYYYYY is an extension that further classifies the result code. The names and numeric values for existing result codes are fixed and unchanging. However, new result codes, and especially new extended result codes, might appear in future releases of SQLite.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about SQLite Result Codes or Error Codes and Error Messages or Warnings on Windows, Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *