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
