Re: [sqlite] blob + rowID Insert question

Thanks!! -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: sexta-feira, 29 de Agosto de 2014 00:20 To: sqlite-users@sqlite.org Subject: Re: [sqlite] blob + rowID Insert question On 8/28/2014 2:18 PM

Re: [sqlite] blob + rowID Insert question

On 8/28/2014 2:18 PM, Carlos Ferreira wrote: In the next line: UPDATE myTable SET theBlob = WHERE id = The "whatever" is a long string containing the data? The "whatever" should be ? (question mark) - a parameter placeholder ( could be another one). Prepare the statement, bind the data to

Re: [sqlite] blob + rowID Insert question

On 28 Aug 2014, at 7:18pm, Carlos Ferreira wrote: > 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

Re: [sqlite] blob + rowID Insert question

lite] 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 = WHERE id = Simon. _

Re: [sqlite] blob + rowID Insert question

Thanks :) :) -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

Re: [sqlite] blob + rowID Insert question

On 28 Aug 2014, at 7:06pm, Carlos Ferreira wrote: > Is there any way to replace a BLOB for a give ROW ID? Use the UPDATE command: UPDATE myTable SET theBlob = WHERE id = Simon. ___ sqlite-users mailing list

[sqlite] blob + rowID Insert question

Hi All, I have a table with one unique column of the type BLOB. Because I am using the direct SQLite functions to read and write BLOBS, the access is made referencing the ROW IDs. Is there any way to replace a BLOB for a give ROW ID? If I perform DELETE and INSERT I am not sure the