Subject | Handling keywords as column names |
---|---|
Author | Alec Swan |
Post date | 2009-09-16T16:55:29Z |
We are porting our legacy database to Firebird. One of the problems we ran
into is the way Firebird handling queries which select column which names
are Firebird keywords. For example, executing the first query throws
"Invalid token." error while the second query works just fine:
1. select SIZE from physical_copy
2. select "SIZE" from physical_copy
Escaping all column names and tables requires a lot of changes to the legacy
code. Is there a way to configure Firebird to gracefully handle these
situations, e.g. by automatically escaping column name?
Thanks,
Alec
[Non-text portions of this message have been removed]
into is the way Firebird handling queries which select column which names
are Firebird keywords. For example, executing the first query throws
"Invalid token." error while the second query works just fine:
1. select SIZE from physical_copy
2. select "SIZE" from physical_copy
Escaping all column names and tables requires a lot of changes to the legacy
code. Is there a way to configure Firebird to gracefully handle these
situations, e.g. by automatically escaping column name?
Thanks,
Alec
[Non-text portions of this message have been removed]