On 15 Jul 2011, at 4:11pm, Jim Morris wrote: > On 7/15/2011 1:26 AM, Mattia wrote: >> - deleting the old database (data.db) and renaming new.db with the >> correct name (new.db becomes data.db). > After this step, as a test, reopen the connection to new.db and ensure > that the data is there. > > Are you sure a commit is done before closing connection?
I don't think Mattia has declared any transactions at all, so each change is done as its own transaction. But your other point is valid: Mattia: you are actually performing some instruction to close the database, right ? You're not just letting your application exit ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users