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.
