Small. Fast. Reliable.
Choose any three.

SQLite C Interface

Move a BLOB Handle to a New Row

int sqlite3_blob_reopen(sqlite3_blob *, sqlite3_int64);

R-28555-32340:[This function is used to move an existing BLOB handle so that it points to a different row of the same database table. ] R-59275-48655:[The new row is identified by the rowid value passed as the second argument. ] Only the row can be changed. R-45889-48790:[The database, table and column on which the blob handle is open remain the same. ] Moving an existing BLOB handle to a new row is faster than closing the existing handle and opening a new one.

R-53739-48047:[The new row must meet the same criteria as for sqlite3_blob_open() - it must exist and there must be either a blob or text value stored in the nominated column. ] R-55970-49067:[If the new row is not present in the table, or if it does not contain a blob or text value, or if another error occurs, an SQLite error code is returned and the blob handle is considered aborted. ] R-63408-55464:[All subsequent calls to sqlite3_blob_read(), sqlite3_blob_write() or sqlite3_blob_reopen() on an aborted blob handle immediately return SQLITE_ABORT. ] R-63084-42258:[Calling sqlite3_blob_bytes() on an aborted blob handle always returns zero. ]

R-01277-06213:[This function sets the database handle error code and message. ]

See also lists of Objects, Constants, and Functions.