Hello, sorry for my late reply but I've been away the past week. I've tried doing transactions (committing and disposing them after each one) and yes, I've closed the database after doing my operations, with no luck at all.
Mat. 2011/7/15 Simon Slavin <slav...@bigfraud.org> > > 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 > -- -mat _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
