On Feb 28, 2009, at 3:50 AM, Igor Tandetnik wrote: > All statements prepared with sqlite3_prepare[16] are invalidated > whenever you change database schema in any way. Next time you use > such a > statement, you get SQLITE_MISUSE error and you have to finalize and > re-prepare it. > Use the newer sqlite3_prepare[16]_v2 API: it stores the text of the > statement internally, and automatically re-prepares it as necessary.
Yes, that what I used and still use (sqlite3_prepare_v2). And the statement prepared was a SELECT statement that queries the existence of a table. I remember reading sqlite3.h that says use v2 instead, and I did, that's why it's more puzzling... d. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
