On Thu, 2005-02-24 at 15:05 +0100, Bielik, Robert wrote: > Hmmm... what is this? When using sqlite3_get_table it goes through > sqlite3_exec which extracts > values from columns with sqlite3_column_text (!!!). What about blobs? A blob > can actually contain > a number of null bytes! What is the recommended procedure to extract a blob > if sqlite3_exec doesn't cut it?? >
sqlite3_get_table() and sqlite3_exec() are legacy APIs in place to support older programs. They are not recommended for new code. Use instead: sqlite3_prepare() sqlite3_step() sqlite3_finalize()