All,
I am using SQLite version 3.7.8. I am receiving the SQLITE_IOERR result code
from sqlite3_prepare_v2 function when attempting to compile a PRAGMA statement
on a read-only database where a rollback journal file also exists. Is it
possible to force SQLite to ignore rollback journal files (or WAL files) ?
My scenario:
Database with rollback journal exist in the same directory.
./test.db
./test.db-journal
Open the database in read-only mode. Returns SQLITE_OK.
sqlite3_open_v2("test.db", &db, SQLITE_OPEN_READONLY, NULL)
Prepare pragma statement for database. Returns SQLITE_IOERR if rollback
journal is present, SQLITE_OK if rollback journal is not present.
sqlite3_prepare_v2(db, "PRAGMA table_info(test_table);", 30,
&stmt, NULL);
Is there a method to stop sqlite3_prepare_v2 from trying to apply the rollback
journal?
Thank you.
Bryan
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
