Write Data Into A BLOB Incrementally

int sqlite3_blob_write(sqlite3_blob *, const void *z, int n, int iOffset);

This function is used to write data into an open blob-handle from a user supplied buffer. n bytes of data are copied from the buffer pointed to by z into the open blob, starting at offset iOffset.

If the blob-handle passed as the first argument was not opened for writing (the flags parameter to sqlite3_blob_open() was zero), this function returns SQLITE_READONLY.

This function may only modify the contents of the blob; it is not possible to increase the size of a blob using this API. If offset iOffset is less than n bytes from the end of the blob, SQLITE_ERROR is returned and no data is written. If n is less than zero SQLITE_ERROR is returned and no data is written.

On success, SQLITE_OK is returned. Otherwise, an SQLite error code or an extended error code is returned.

See also lists of Objects, Constants, and Functions.