D. Richard Hipp wrote:
>
>
> 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
>
>
This was indeed the problem. I was reading the database with the windows
version of sqlitebrowser from sourceforge. This viewer did not display the
columns from tables with the minus sign. I tried another viewer and the
columns are displayed now. Thanks for the help.
--
View this message in context:
http://www.nabble.com/Minus-sign-in-table-name-tp23368986p23370199.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
