Hi, Thanks for your question.
Can I run the PRAGMA command without using sqlite3_exec command? According to the sqlite documentation the PRAGMA vacuum commands are the following : For query -> PRAGMA auto_vacuum; For Set -> PRAGMA auto_vacuum = 0 | none | 1 | full | 2 | incremental; While querying PRAGMA vacuum command, where the retrieved result is stored? Do I need to define a variable or special structure for this? I'll appreciate if you can specify the correct PRAGMA syntax. Thanks in advance, -Raviv. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Cote Sent: Monday, March 03, 2008 6:48 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] PRAGMA auto_vacuum Raviv Shasha wrote: > > Sqlite_exec (pDB, "PRAGMA auto_vacuum = 1", NULL, 0, &errMsg); > Raviv, That is correct, but you should not the following detail from http://www.sqlite.org/pragma.html > Therefore, auto-vacuuming must be turned on > before any tables are created. It is not possible to enable or > disable auto-vacuum after a table has been created. HTH Dennis Cote _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
