On May 4, 2009, at 10:18 AM, 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.
Works fine for me on both linux and mac, on both new and historical versions of SQLite. What makes you think it isn't working? You say "the table is created with [the] TST column...". How do you know? Perhaps it is your test for the presence of the TST column that contains the error? D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
