Ken & Deb Allen wrote:
So, would this problem still exist if the code were to open two
'connections' to the database, issue the SELECT on one open connection
and then issue the CREATE TABLE via the other open connection?
I'm new to this to, but I think it depends on if that
'db.execute()' function you are using deals with
SQLITE_SCHEMA errors as suggested in...
http://www.sqlite.org/faq.html#q17 or if it uses
sqlite3_exec() instead.
Is that a wrapper object you wrote?
Your running 'CREATE TABLE' statement *I think*
invalidates all currently compiled statements so that
they have to be recompiled. This does not matter
if it is across threads or across processes.
-
Kervin
