On 06/30/2012 04:27 AM, Jeff Archer wrote:
Simon Slavin slavins at bigfraud.org Fri Jun 29 17:16:36 EDT 2012
Do you do the _prepare() first, then make a change to the database schema
? For instance
Start of app
Prepare the INSERT statement
CREATE TABLE
Bind the INSERT statement
Step the INSERT statement
No.
Create Table
Then in a separate function
Prepare
Bind
Step
Finalize
If the prepare/step/finalize uses a different database handle,
it may prepare the statement using an old version of the
schema still cached in memory. Then, when the statement is
executed and the database file read, SQLite realizes the old
schema is out of date, loads the new schema and re-prepares
the statement.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
