HRESULT 0x87AF0713 (SQLITE_E_CONSTRAINT

Status / error code:

Category:

Constant name:

Source:

Facility:

Operating System:

Description:

A SQLite trigger deliberately aborted the SQL statement.

Previous	Next
SQLITE_E_IOERR_FSTAT	SQLITE_E_IOERR_UNLOCK

SQLITE_E_CONSTRAINT_TRIGGER

SQLITE_E_CONSTRAINT_TRIGGER corresponds to SQLITE_CONSTRAINT_TRIGGER. A trigger executed RAISE() and caused the statement to abort.

Inspect trigger definitions on the affected table and capture the message supplied to RAISE().
Check the BEFORE/AFTER trigger order and whether another trigger changed the values being validated.
Treat the trigger as application logic: the correct fix is usually in the input or business rule, not in SQLite storage settings.

SELECT name, sql FROM sqlite_master WHERE type = 'trigger';