> I would test it, but "When the pragma is issued with no argument, it > returns the setting of the flag. This pragma does not tell which file > format the current database is using. It tells what format will be used > by any newly created databases."
Hmm. I can't get the pragma to return a value at all. SQLite version 3.6.10 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> pragma default_file_format; sqlite> create table test (i); sqlite> pragma default_file_format; sqlite> insert into test values(1); sqlite> pragma default_file_format; sqlite> SQLite version 3.6.10 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> pragma default_file_format; sqlite> pragma default_file_format=false; sqlite> pragma default_file_format; sqlite> pragma default_file_format=true; sqlite> pragma default_file_format; sqlite> RW Ron Wilson, Engineering Project Lead (o) 434.455.6453, (m) 434.851.1612, www.harris.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users