|
int sqlite3_blob_open( sqlite3*, const char *zDb, const char *zTable, const char *zColumn, sqlite3_int64 iRow, int flags, sqlite3_blob **ppBlob );
This interfaces opens a handle to the blob located in row iRow,, column zColumn, table zTable in database zDb; in other words, the same blob that would be selected by:
SELECT zColumn FROM zDb.zTable WHERE rowid = iRow;
If the flags parameter is non-zero, the blob is opened for read and write access. If it is zero, the blob is opened for read access.
On success, SQLITE_OK is returned and the new blob handle is written to *ppBlob. Otherwise an error code is returned and any value written to *ppBlob should not be used by the caller. This function sets the database-handle error code and message accessible via sqlite3_errcode() and sqlite3_errmsg(). (TODO: We should go through and mark all interfaces that behave this way with a similar statement)
See also lists of Objects, Constants, and Functions.