bitzzz wrote: > 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. >
Did you try: CREATE TABLE "TEST1-TEST" (TST TEXT); (note the use of double quotes) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users