> -----Original Message----- > From: Robert Simpson [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 23, 2006 10:30 AM > To: sqlite-users@sqlite.org > Subject: RE: [sqlite] "SQL logic error or missing database" > [snip] > rc = sqlite3_step(pStmt3); > if (rc) rc = sqlite3_reset(pStmt3); > if (rc == SQLITE_SCHEMA) { > rc = sqlite3_finalize(pStmt3); > // Todo: re-prepare the statement according to the FAQ at > // http://www.sqlite.org/faq.html#q17 > }
Bah the above code isn't right. Check for 100 and 101 after the first sqlite3_step() before checking for an error rc code.
