What does HRESULT 0x87AF0A13 (SQLITE_E_CONSTRAINT_ROWID) mean?

 
Previous Next
SQLITE_E_IOERR_DELETE SQLITE_E_IOERR_BLOCKED

SQLITE_E_CONSTRAINT_ROWID

SQLITE_E_CONSTRAINT_ROWID corresponds to SQLITE_CONSTRAINT_ROWID. The operation attempted to create a row whose rowid is not unique.

What to check

  • Check whether the application explicitly supplies rowid, _rowid_, oid, or an INTEGER PRIMARY KEY alias.
  • Review import or restore code that may reuse row identifiers from another database.
  • Do not assume this is the same as a generic UNIQUE violation; rowid behavior is specific to rowid tables.
SELECT rowid, * FROM your_table WHERE rowid = ?;

SQLite: SQLITE_CONSTRAINT_ROWID

SQLite: Rowid Tables

SQLite: Conflict Resolution


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