On 5/23/06, Robert Simpson <[EMAIL PROTECTED]> wrote:
After sqlite3_step() fails, you should call sqlite3_reset() on the statement. This is what will give you the SQLITE_SCHEMA error, indicating you need to re-prepare your statement.
That doesn't seem right. The change was made and committed then the database statement prepared. The change should have already been written so the prepare should have gotten the latest stuff. Does it need to be closed and reopened for a schema change to be recognized?
