papillon <[EMAIL PROTECTED]> wrote:
I update a record with the following code:
rc = sqlite3_exec(waypoint_db, sqlstring, callback, 0, &zErrMsg);
function return SQLITE_OK.
I use a SELECT to see the records and yes, the above records seems to
be updated, it shows the new value.
I quit the application (correctly closing the db), open it again and
... the record is showing the value prior to the update call.
So it seems that even if a SELECT statement show that the value has
been changed, these updates are not committed to disk ?
Have you, by any chance, started a transaction (with BEGIN statement)
but then closed the connection without committing it? This is equivalent
to rolling it back.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
