Hi,
D. Richard Hipp wrote:
sqlite3_prepare only processes the first statement in your list of
SQL statements. It then returns a pointer to the beginning of the
second statement so that you can process them all in a loop. But
your code appears to omit this loop and thus is processing only
the first one. It never reaches the SELECT.
On the processing of multiple SQL statements - should sqlite3_finalize() be
called on each iteration, or can sqlite3_prepare() be called right away and then
sqlite3_finalize() called only when all the processing is finished?
Thanks,
Eugene
