On 19 Mar 2014, at 10:53pm, m.d.berce...@gmail.com wrote: > I'm running the "pragma auto_vacuum = 'full'" a C++ code, then I go to > SQLiteSpy, open the database and run pragma auto_vacuum in the query window > and the result is 0.
The syntax is PRAGMA auto_vacuum = FULL no quotes or apostrophes. > I tried "pragma auto_vacuum = 1" and still the same, it doesn't seem to > keep the setting. According to the documentation for the command you need to issue the 'VACUUM' command to change the status of an existing database: <http://www.sqlite.org/pragma.html#pragma_auto_vacuum> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users