User Tools

Site Tools


sqlite_error_handling.htm
Navigation:  SQL Drivers > SQLite Accelerator >SQLite Error Handling Previous pageReturn to chapter overviewNext page

SQLite Accelerator Error Handling

FILERRORCODE() can be used to obtain the error code returned from SQLite.

Below is a table with all the error codes that FILEERRORCODE() will return after a call to an SQLite file.  For programs designed to target non-English speaking users or ones that wish to change the error messages, the table also includes the CLAMSGerrornumber values that must be used in the env file.

FILEERRORCODE CLAMSG Error Number Message
1 4201 SQL error or missing database
2 4202 Internal logic error in SQLite
3 4203 Access permission denied
4 4204 Callback routine requested an abort
5 4205 The database file is locked
6 4206 A table in the database is locked
71 4207 A malloc() failed
82 4208 Attempt to write a readonly database
9 4209 Operation terminated by sqlite3_interrupt()
10 4210 Some kind of disk I/O error occurred
11 4211 The database disk image is malformed
12 4212 Unknown opcode in sqlite3_file_control()
13 4213 Insertion failed because database is full
14 4214 Unable to open the database file
15 4215 Database lock protocol error
16 4216 Database is empty
17 4217 The database schema changed
18 4218 String or BLOB exceeds size limit
19 4219 Abort due to constraint violation
20 4220 Data type mismatch
21 4221 Library used incorrectly
22 4222 Uses OS features not supported on host
232 4223 Authorization denied
24 4224 Auxiliary database format error
25 4225 2nd parameter to sqlite3_bind out of range
26 4226 File opened that is not a database file
80 4280 Could not load sqlite3.dll : (%1) %2You can download the dll from www.sqlite.org3
81 4281 Could not find the procedure %1 in sqlite3.dll4
82 4282 No OWNER attribute specified
100 4300 sqlite3_step() has another row ready
101 4301 sqlite3_step() has finished executing

Notes:

1:        ERRORCODE() will return 8, NoMemErr

2:        ERRORCODE() will return 5, NoAccessErr

3: %1 will be substituted with the error code returned from the operating system.  %2 will be substituted with the matching error message.  If you set a replacement string, you do not need to have %1 or %2 in your string.

4:        %1 will be substituted with the name of the missing procedure

.

sqlite_error_handling.htm.txt · Last modified: 2021/04/15 15:57 by 127.0.0.1