| **Navigation:**  SQL Drivers > [[sqlite driver.htm|SQLite Accelerator]] >SQLite Error Handling | [[sqlite multi-user.htm|{{btn_prev_n.gif|Previous page}}]][[sqlite driver.htm|{{btn_home_n.gif|Return to chapter overview}}]][[sql driver strings.htm|{{btn_next_n.gif|Next 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

.