| Previous | Next |
| SQLITE_E_IOERR_DIR_FSYNC | SQLITE_E_IOERR_TRUNCATE |
SQLITE_E_CONSTRAINT_NOTNULL
SQLITE_E_CONSTRAINT_NOTNULL corresponds to SQLITE_CONSTRAINT_NOTNULL. An INSERT or UPDATE tried to store NULL in a column declared NOT NULL.
What to check
- Find which bound parameter or expression became NULL rather than assuming the application omitted the column.
- Check default values and trigger logic; either can transform an apparently valid input into a NULL assignment.
- Change the schema only when NULL is genuinely valid for the domain, not merely to make the current statement pass.
SELECT sql FROM sqlite_master WHERE type = 'table' AND name = 'your_table';
SQLite: SQLITE_CONSTRAINT_NOTNULL
Looking for a different code? Search another status or error code.