On 19 Nov 2013, at 6:00am, Joshua Grauman <[email protected]> wrote:
> sqlite3_open_v2("sqlite3.database.filename");
> sqlite3_exec("BEGIN IMMEDIATE");
> file.open("sqlite3.database.filename");
> file.readAll();
> file.close();
> sqlite3_exec("ROLLBACK");
> sqlite3_close();
>
> So does this look like I should always read/write the database properly?
That looks like it should work. Make sure that your defaults for file.open()
don't try to lock the file.
I would probably use "END" rather than "ROLLBACK". SQLite will know that you
didn't make any changes and will probably execute exactly the same code, but I
don't like seeing "ROLLBACK" unless something went wrong.
Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users