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, Carlos Ferreira wrote:
> In the next line:
>
> UPDATE myTable SET theBlob = <whatever> WHERE id = <theID>
>
> The "whatever" is a long string containing the data?

The "whatever" should be ? (question mark) - a parameter placeholder
(<theID> could be another one). Prepare the statement, bind the data to the
parameter using sqlite3_bind_blob (which you have already discovered), then
execute the statement.
--
Igor Tandetnik

_______________________________________________
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

Reply via email to