One other question: I use the
SQLite3_BindBlob to add a new blob to a given record. From this point on I know how to change the BLOB ( but not its size ) using the incremental BLBO direct Access functions. Using your suggestion of the UPDATE Statement, and assuming I have a block of memory with pointer p and size s ( different from the previous size ), that I want to use as the data of my new blob, do you suggest I create a very long string as the statement? In the next line: UPDATE myTable SET theBlob = <whatever> WHERE id = <theID> The "whatever" is a long string containing the data? How should I serialize it? What kind of encoding? Thanks Carlos -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: quinta-feira, 28 de Agosto de 2014 19:08 To: General Discussion of SQLite Database Subject: Re: [sqlite] blob + rowID Insert question On 28 Aug 2014, at 7:06pm, Carlos Ferreira <car...@csiberkeley.com> wrote: > Is there any way to replace a BLOB for a give ROW ID? Use the UPDATE command: UPDATE myTable SET theBlob = <whatever> WHERE id = <theID> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
