I see; the first part... " result of the pragma or the error message if the pragma fails" I missed the or part... or rather missed the part before the or.
On Sun, Feb 22, 2015 at 8:13 PM, J Decker <d3ck0r at gmail.com> wrote: > So now that I have the added complexity of my own vfs in which to make a > sqlite vfs... I'm having some issues. > > Hmm... > One of the first things I do is 'pragma journal_mode=WAL' > I return sqlite_ok; but the result has 0 columns, whereas my command line > tool returns a column 'journal_mode' and a row 'WAL'.. > > is WAL somehow dependant on the VFS? > > I was just going to note, that although I'm setting wall, and it does 3 > probes to see if the wal file exists... and probes a lot actually - though > I guess it's assuming other processes are going to be manipulating the > file? (is there a compile option to disable that, and assume it's the only > one with access to the database?) > > It never created a -wal file... it does use a temp file once when I > start... and I guess NULL to the open is expecting a unique file every time > the open method of the vfs is called? > > it does create a -journal file.. (and deletes) so I guess it's normal mode > is working.... > > >

