I use both int sqlite3_errcode() and sqlite3_errmsg(). Here is what they return (I get 3 different types of errors in different runs): 1, SQL logic error or missing database. 1, unrecognized token "" (there's a non printable character like a rectangle within the quotes). 1, SQL logic error or missing database, sqlite3_get_table() called with two or more incompatible queries (this last print is obtained from zErrMsg returned when the return value from sqlite3_get_table() is not SQLITE_OK)
Also, the program is written to print an error and then continue in the infinite loop. I can find a few errors in query execution, but it is after an error in insertion (sqlite3_step() != SQLITE_DONE) that the program quits by itself. D. Richard Hipp wrote: > > > On Oct 31, 2008, at 9:46 AM, dbikash wrote: >> >> I get a SQLite error 1 (SQL logic error >> or missing database). What could be the problem? > > Is that the error message text that SQLite returns: "SQL logic error > or missing database"? Or is that just the meaning of SQLITE_ERROR > that you looked up? What error message does sqlite3_errmsg(db) return? > > D. Richard Hipp > [EMAIL PROTECTED] > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/%22SQL-logic-error-or-missing-database%22-with-multithreaded-program-tp20266281p20268213.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
