"Mike McGonagle" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > My impression from what I have seen is that Blobs are dealt with in a > different way than other data types. Am I correct in assuming that > Blobs need to be created explicitly, and then you repeatedly call > 'sqlite3_blob_write()' to store them, and 'sqlite3_blob_read()' to > read them?
That's a fairly recent API. The old way, that still happily works, is to use prepared parameterized statements (see sqlite3_prepare et al) together with sqlite3_bind_blob. You bind a BLOB just as you would any other parameter. > Also, can you have a select statement that retrieves regular data as > well as blob data in the same query? Yes. To extract BLOB field, use sqlite3_column_blob. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
