> 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

Reply via email to