On 17 Apr 2015, at 11:59am, Janke, Julian <julian.janke at capgemini.com> wrote:
> I've changed the stmt to "SELECT 'Hello World !!';" > In this case, > > sqlite3_step() returns SQLITE_ROW > sqlite3_column_text() returns 'Hello World !!' > > That, looks right. I agree. And it shows that your C code is working perfectly. For comparison I will show you what the shell tool does with the PRAGMA command: dyn-171-167:~ simon$ sqlite3 ~/Desktop/test.sqlite SQLite version 3.8.5 2014-08-15 22:37:57 Enter ".help" for usage hints. sqlite> CREATE TABLE myTable (myColumn TEXT); sqlite> INSERT INTO myTable VALUES ('first line'); sqlite> INSERT INTO myTable VALUES ('second line'); sqlite> SELECT * FROM myTable; first line second line sqlite> PRAGMA journal_mode=WAL; wal sqlite> PRAGMA journal_mode=WAL; wal sqlite> .quit As you can see, the PRAGMA command returns a response of 'wal' even if the mode is already WAL. My understanding of your previous answers is that the command returns SQLITE_OK, but no lines of data. That does seem wrong to me. I suspect that you are coming up with some aspect of writing your own VFS. I'm sorry but I do not know enough about writing your own VFS to understand what to do next. I hope somebody else reading this can help you further. Simon.