Subject | Reserved field names |
---|---|
Author | rich996478 |
Post date | 2004-06-01T10:01:46Z |
Hi,
I'm not sure if this is the right forum to ask this question, but is
there any technical reason you can't create a field in a database with
the name YEAR or TYPE without quoting it.
Currently I'm porting a application that I use with Oracle to
Firebird, and there seems to be many field names that I cannot use,
even some slightly misspelled words like RESERV. Anyway, I'm just
wondering if there is any technical reason why these words cannot used
as field names. I can't imagine any sql statement that these would
cause parsing problems with. Ok, maybe with TYPE, but not the others
:-)
Any ideas?
Aloha,
Rich
I'm not sure if this is the right forum to ask this question, but is
there any technical reason you can't create a field in a database with
the name YEAR or TYPE without quoting it.
Currently I'm porting a application that I use with Oracle to
Firebird, and there seems to be many field names that I cannot use,
even some slightly misspelled words like RESERV. Anyway, I'm just
wondering if there is any technical reason why these words cannot used
as field names. I can't imagine any sql statement that these would
cause parsing problems with. Ok, maybe with TYPE, but not the others
:-)
Any ideas?
Aloha,
Rich