On 6/15/06, James Butts <[EMAIL PROTECTED]> wrote:
In the main thread, I open a connection to database and create a timer function and start a worker thread. The worker thread establishes its own separate connection to database. The worker thread creates a table and then signals the main thread. The timer function in the main thread drops the table and signals back to the worker thread. The worker thread creates the table again and receives no error. However, if the worker thread tries to insert a record into that table, I get back a SQLITE_ERROR error.
Are you perhaps getting a "schema changed" error? It has to recache the new schema after the drop. If the other thread has it open that can easily happen. -- SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Cthulhu Bucks! http://www.cthulhubucks.com
