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

Reply via email to