What does HRESULT 0x87AF0513 (SQLITE_E_CONSTRAINT_NOTNULL) mean?

 
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

SQLite: NOT NULL Constraints

SQLite: Conflict Resolution


Looking for a different code? Search another status or error code.