On 26 Aug 2017, at 10:58pm, Bart Smissaert <[email protected]> wrote:
> I looked at my application code and that seems OK, but the output is a > single null value. > What kind of output should I get? That’s just SQLite returning SQLITE_OK because the command ran without problems. You need to execute that PRAGMA command as if it’s a SELECT command. It should return a table. If the tools you’re using do not allow this, turn the PRAGMA into a SELECT command as follows: SELECT * FROM PRAGMA optimize(1); Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
