What does HRESULT 0x87AF0019 (SQLITE_E_RANGE) mean?

 
Previous Next
SQLITE_E_FORMAT SQLITE_E_NOTADB

SQLITE_E_RANGE

SQLITE_E_RANGE corresponds to SQLite SQLITE_RANGE. A SQLite API parameter was outside its valid range; a common example is a bind index that does not exist in the prepared statement.

What to check

  • Compare the number and names of placeholders in the prepared SQL with every bind call.
  • Check zero-based versus one-based indexing assumptions in language bindings; SQLite bind parameter indexes start at one.
  • Treat this as a code defect and add tests for generated SQL and optional parameters.
SELECT ?1;

SQLite: Result and Error Codes


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