Re: [sqlite] Question on how to enter blobs in sqlite3

2006-04-05 Thread Roman
Thank you for the reply Thomas, I found that an extra space would not let me set the field to a value. I went over your code, and I managed to get the script working for me. I am looking through ther bind functions to see the benefit. Thanks again, My sqlite3 is working good now, since I know mo

Re: [sqlite] Question on how to enter blobs in sqlite3

2006-04-05 Thread Jay Sprenkle
On 4/4/06, Roman <[EMAIL PROTECTED]> wrote: > Hello, > I am using sqlite3 on am embedded platform. I am using c++ to enter data. I > have BLOB field, and I do not know how to enter hex values from a data > string. I am trying to use update, but how do I enter col_name=' data ' > format? > > How doe

Re: [sqlite] Question on how to enter blobs in sqlite3

2006-04-05 Thread Thomas Chust
On Tue, 4 Apr 2006, Roman wrote: [...] I have tried sqlite> select * from loc_configuration; 0|0|18|52|86|4|24|22|51|116|39|15|0|0|0|0|0|0|0|0|0|0|0|0 The blob is the one before the last one, and the length is the very last one The serials are second, third , fourth and fifth columns. sqlite>

Re: [sqlite] Question on how to enter blobs in sqlite3

2006-04-04 Thread Roman
Hi Thomas, I have tried sqlite> select * from loc_configuration; 0|0|18|52|86|4|24|22|51|116|39|15|0|0|0|0|0|0|0|0|0|0|0|0 The blob is the one before the last one, and the length is the very last one The serials are second, third , fourth and fifth columns. sqlite> UPDATE loc_configuration SE

Re: [sqlite] Question on how to enter blobs in sqlite3

2006-04-04 Thread Thomas Chust
On Tue, 4 Apr 2006, Roman wrote: [...] I am using sqlite3 on am embedded platform. I am using c++ to enter data. I have BLOB field, and I do not know how to enter hex values from a data string. [...] Hello, if you need to put BLOB data verbatim into an SQL statement, SQLite3 supports syntax