> SELECT * FROM PRAGMA optimize(1); That doesn't prepare, error at (
RBS On Sat, Aug 26, 2017 at 11:03 PM, Simon Slavin <[email protected]> wrote: > > > 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 > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
