From 18657a960e125336f704ea058e25c27bd3900dcb Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 5 May 2024 19:28:19 +0200 Subject: Adding upstream version 3.40.1. Signed-off-by: Daniel Baumann --- www/c3ref/blob_reopen.html | 149 +++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 149 insertions(+) create mode 100644 www/c3ref/blob_reopen.html (limited to 'www/c3ref/blob_reopen.html') diff --git a/www/c3ref/blob_reopen.html b/www/c3ref/blob_reopen.html new file mode 100644 index 0000000..b818d00 --- /dev/null +++ b/www/c3ref/blob_reopen.html @@ -0,0 +1,149 @@ + + + + + +Move a BLOB Handle to a New Row + + + +
+ + + +
+
+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);
+
+

+This function is used to move an existing BLOB handle so that it points +to a different row of the same database table. The new row is identified +by the rowid value passed as the second argument. Only the row can be +changed. 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.

+ +

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. 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. +All subsequent calls to sqlite3_blob_read(), sqlite3_blob_write() or +sqlite3_blob_reopen() on an aborted blob handle immediately return +SQLITE_ABORT. Calling sqlite3_blob_bytes() on an aborted blob handle +always returns zero.

+ +

This function sets the database handle error code and message. +

See also lists of + Objects, + Constants, and + Functions.

+ -- cgit v1.2.3