I am converting an existing database to sqlite format, but I got the
following problem:

When I create a table name with a minus sign inside then the following
column definitions are ignored.
So:

CREATE TABLE 'TEST1-TEST' (TST TEXT);

refuses to create the column TST in the table TEST1-TEST. The table is
created without TST column without any error.

CREATE TABLE 'TEST1TEST' (TST TEXT);

works ok.

So my question is what is wrong in my SQL statement ? I also tried with
alter table, but got the same result.
-- 
View this message in context: 
http://www.nabble.com/Minus-sign-in-table-name-tp23368986p23368986.html
Sent from the SQLite mailing list archive at Nabble.com.

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to