sqlite.exe db_name .dump It missed : table name is un quoted.(INSERT statement) database conversion fails (version 2 to 3)
sqlite -version 2.8.17 --------- dump_test.sql create table "where" (id INTEGER); INSERT INTO "where" VALUES(1); ----------------------------------- @rem create database sqlite.exe dump_test.db < dump_test.sql sqlite.exe dump_test.db .dump > test1.sql @rem test1.sql : missed : table name is un quoted. sqlite.exe dump_test.db .dump | sqlite3.exe test_db3.db @rem sqlite3.exe test_db3.db < test1.sql @rem error occures. @rem : syntax error _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users