I am not sure if this is relevant but sqlite3_prepare_v2 build a statement with 0 columns, i.e. pVm->nResColumn = 0;
Also the operation code of the prepared statement shows OP_Init (153) instead of OP_JournalMode (12). Again here you have my exec statement: " sqlite3_exec(ddDB, "PRAGMA journal_mode = off",NULL, 0, &zErrMsg); " With best regards, Adrian Dobrean 905-315-4953 -----Original Message----- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Dobrean, Adrian Sent: Tuesday, July 05, 2016 11:19 AM To: SQLite mailing list Subject: Re: [sqlite] unable to set 'PRAGMA journal_mode = off' for vfs My understanding is that as result of this command " PRAGMA journal_mode = off" the journal mode should get set to "PAGER_JOURNALMODE_OFF". However in my case even though I get no error and the journal_mode stays set to "0" instead of "PAGER_JOURNALMODE_OFF " (which is 2). Basically I need to turn off the journaling for this database. With best regards, Adrian Dobrean 905-315-4953 -----Original Message----- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Simon Slavin Sent: Tuesday, July 05, 2016 11:13 AM To: SQLite mailing list Subject: Re: [sqlite] unable to set 'PRAGMA journal_mode = off' for vfs On 5 Jul 2016, at 4:05pm, Dobrean, Adrian <adrian.dobr...@emc.com> wrote: > I am not getting any error, i.e. sqlite3_exec returns 0 and zErrMsg is NULL. That indicates your command worked correctly. What makes you think your command is failing ? After executing PRAGMA journal_mode = off please execute PRAGMA journal_mode and tell us what value is in the table the command returns. It should tell you what setting journal_mode has now. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users