On 16 Apr 2015, at 2:33pm, Janke, Julian <julian.janke at capgemini.com> wrote:
> rc = sqlite3_step(stmt);
> --> returns SQLITE_DONE
After the above two lines, print the value returned by
sqlite3_column_text(stmt, 0)
I'm not good at C off the top of my head but I think it's something like
-----------------
const unsigned char * theText;
[...]
rc = sqlite3_prepare_v2(db, "PRAGMA journal_mode=WAL;", 24, &stmt, NULL);
rc = sqlite3_step(stmt);
theText = sqlite3_column_text (stmt, 0);
printf ("text returned: %s", theText);
rc = sqlite3_finalize(stmt);
-----------------
Hope if I got it wrong someone else will tell you. By the way, you can also
check the values returned from sqlite3_finalize() and sqlite3_close() since
they can tell you useful things if something went wrong.
Simon.