sqlite_error_handling.htm
Navigation: SQL Drivers > SQLite Accelerator >SQLite Error Handling | |
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