I believe only WAL mode is sticky. Not using the pragma seems to generate deletions as normal.
The missing data was from after the file was closed. I am still looking into rollback, but why would journal mode matter? Marc On Dec 18, 2012, at 12:02 PM, "Simon Slavin" <slav...@bigfraud.org> wrote: > > On 18 Dec 2012, at 3:04pm, Marc L. Allen <mlal...@outsitenetworks.com> wrote: > >> I also have no additional information as to why having PERSIST mode on >> prevents the database from being updated/correct. I did check the >> sqlite3_close command, and I'm passing it the connection received from >> sqlite3_open. It returns SQLITE_OK. > > Well, it seems you're doing it right. It's possible that your operating > system doesn't show updates until the file is closed. > > The other thing is that journal mode is meant to be sticky with each database > file. It may be that when you issue 'PRAGMA journal_mode', even though > you're setting the same mode that's already active, SQLite reinitialises the > journal. Now you have the correct journal mode set for your database files > you shouldn't need to use that PRAGMA again. Does that fix things ? > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
