On 4 Jun 2010, at 3:25am, Wincent wrote: > After the DROP, a CREATE TABLE command is executed to create a table > with the same name as structure.
Then some of the file which contained data from the old TABLE has probably already been overwritten. It may be that some data is already irretrievable. The more you do to that database file, the more chance you have of overwriting data that used to be in that TABLE. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users