Ned Fleming wrote: > Is it possible to dump an in-memory sqlite database (or table?) to a > file from within Tcl? > > I create it like so: > > sqlite3 dbFireData :memory: > > and insert a bunch of records, and then commit.
Is there reason not to attach a file (old or new), and either create table realfile.newtablecopy as select * from main.originaltable or else create the new table with ~ the same create table statement used for the original table, and then insert into realfile.newtablecopy select * from main.originaltable ? The first method copies all the data, but will drop any special thingies from the column definitions. HTH, Gerry _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users