Subject | Using key words as column names |
---|---|
Author | djmp3_2k |
Post date | 2005-07-15T07:20:24Z |
How can I use the key word "TYPE" as a table column name?
Currently there is an applicaiton that is using a MSSQL DB. Some tables
have the keyword "TYPE" as a column name. We are trying to migrate to
Firebird and having no luck.
I can create the tables but have issues when trying to query them. In
my query statements I do not encapsulate the column names with quotes.
So a statement like this will not work:
SELECT TYPE FROM TEMPLATES
Although, when using a dialect 3 with firebird alpha 2 it will work. Is
there a way to achieve this in Firebird 1.5?
Currently there is an applicaiton that is using a MSSQL DB. Some tables
have the keyword "TYPE" as a column name. We are trying to migrate to
Firebird and having no luck.
I can create the tables but have issues when trying to query them. In
my query statements I do not encapsulate the column names with quotes.
So a statement like this will not work:
SELECT TYPE FROM TEMPLATES
Although, when using a dialect 3 with firebird alpha 2 it will work. Is
there a way to achieve this in Firebird 1.5?