On Apr 22, 2008, at 8:37 PM, Richard Klein wrote: > I've generated and compiled the SQLite sources > with the option SQLITE_OMIT_PAGER_PRAGMAS. > > If I call sqlite_prepare() and sqlite3_step() > on the SQL statement "PRAGMA cache_size = 100;", > I get return codes of SQLITE_OK and SQLITE_DONE, > respectively, but the cache_size doesn't seem to > change. > > Is this the correct behavior? If so, fine -- > it's just that I would have expected sqlite3_ > prepare() to return an error code. >
When you compile with SQLITE_OMIT_PAGER_PRAGMAS the cache_size pragma is omitted. A feature of the PRAGMA command is that unrecognized pragmas are silently ignored. D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users