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 [mailto:[email protected]] > 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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
