Hello everybody, I'm quite new to sqlite and I have a question about an odd behaviour. I'm using MSVC2003 and latest sqlite version.
I update a record with the following code:
rc = sqlite3_exec(waypoint_db, sqlstring, callback, 0, &zErrMsg);
function returns SQLITE_OK. I use a SELECT to see the records and yes, the above record 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 ? I'm quite lost, any suggestion is really welcome.