I am not getting any error, i.e. sqlite3_exec returns 0 and zErrMsg is NULL.

Also I forgot to mention that "/path/mysqfile" is an empty file.

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 Richard Hipp
Sent: Tuesday, July 05, 2016 11:02 AM
To: SQLite mailing list
Subject: Re: [sqlite] unable to set 'PRAGMA journal_mode = off' for vfs

On 7/5/16, Dobrean, Adrian <adrian.dobr...@emc.com> wrote:
> Hi,
>
> I am unable to turn off journal for vfs (I am using SQLite version 
> 3.8.7.2).
> I am not getting any error and the journal mode does not get set (i.e. 
> to PAGER_JOURNALMODE_OFF).

Maybe you could tell us what the error is?


> Any idea what am I doing wrong? (it used to work in 3.7.5)
>
> "
> sqlite3_open_v2("/path/mysqfile", &ddDB, SQLITE_OPEN_READWRITE | 
> SQLITE_OPEN_CREATE, "myvfs"); sqlite3_exec(ddDB, "PRAGMA journal_mode 
> = off",NULL, 0, &zErrMsg); "
>
> With best regards,
>
> Adrian Dobrean
> 905-315-4953
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
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

Reply via email to