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.

Reply via email to