Hello Simon! Just for your information. I have often receive this error (SQL logic error or missing database) when some constraints failed or keys aren't unique. I use 3.3.4; earlier with version 3.2.8 I had correct responses for non-uniqueness failures. So I think when you update data there may be an error but of course it is not a (SQL logic error or missing database)
WBR, Denis -----Original Message----- From: Simon Posnjak [mailto:[EMAIL PROTECTED] Sent: Friday, September 08, 2006 6:02 AM To: sqlite-users@sqlite.org Subject: [sqlite] UPDATE reports SQL logic error or missing database Hi all! When I try to do UPDATE of a record i get: SQL logic error or missing database (error code 1)? The database is not missing or corrupted because I can UPDATE stuff in it with sqlite3 and I can INSERT into, SELECT from it and also DELETE. My application uses two threads. The first thread does INSERT,UPDATE,DELETE and SELECT in to the db and the other thread only does SELECT. To speed up things I use precompiled query's. They are created at application startup and they last throughout the whole running time of the application. I have read and followed the instructions (http://www.sqlite.org/cvstrac/wiki?p=MultiThreading) on how to build multi threaded applications. Regards Simon ------------------------------------------------------------------------ ----- To unsubscribe, send email to [EMAIL PROTECTED] ------------------------------------------------------------------------ ----- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
