Insert the record.  (Use zeroblob(n) to on the blob field to create an empty n 
byte blob.)
Open the blob and do your I/O
Close the blob.
Carry on with the next record.

> -----Original Message-----
> From: sqlite-users []
> On Behalf Of Mike King
> Sent: Tuesday, 14 March, 2017 17:34
> To: SQLite mailing list
> Subject: [sqlite] Incremental BLOB IO
> Hi,
> I'm trying to understand incremental BLOB IO using the latest
> System.Data.Sqlite and C#.
> I've got some test code working where I can execute a query and using a
> data reader get a SQLiteBlob object and read the blob back. However, I'm
> not clear as to how I can use incremental IO if I'm doing an Insert of a
> new record.
> I appreciate it's a really cheeky thing to ask, but does anybody have an
> example of this?
> Cheers,
> Mike
> _______________________________________________
> sqlite-users mailing list

sqlite-users mailing list

Reply via email to