> Try instead: > > .dump cl1% Apparently, this doesn´t help either. Once I tried to export the table, the application refuses to show the entries in the table.
The database i am opening here is correct, it holds data in cl1 prior to opening it for this step here: Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Arbeit\Arbeit\__Projekte\2007\MMCD\SRC\globe\DB>sqlite3 countries2.db SQLite version 3.6.10 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .o cl1.sql sqlite> .dump cl1% sqlite> select * from cl1; sqlite> Also, a .show statement returns nothing either. It seems as if the database does simply not exist anymore. Furthermore, i got a corrupted version of the database here as the result of my operations as well - this used to be the same database than the one above, yet after exporting and reimporting the data for the cl1 table, it is now corrupted. C:\Arbeit\Arbeit\__Projekte\2007\MMCD\SRC\globe\DB>sqlite3 countries-corrupted.d b SQLite version 3.6.10 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .s sqlite> .s cl1; sqlite> We also experience crashes with the new version, but this may be due to the component we are using (i am not sure it is supporting the new version of sqlite.dll) Do you want me to mail you the corrupted database for further inspection? I also understand that this is not the right place for bugreports eventually. Christophe Leske www.multimedial.de - i...@multimedial.de http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
