Subject | table names with double quotes not recognized |
---|---|
Author | Bart Smissaert |
Post date | 2011-05-10T08:06:03Z |
Sorry, mail went off too early.
Have a Firebird 1.5 database in classic configuration on Windows XP.
As we have at least one table that has a name that is a reserved word (ACTION)
I needed to add double quotes to table names, eg:
select count(rdb$db_key) from "ACTION"
This always used to work fine, but now for some reason this isn't
accepted anymore.
The error message I get in Workbench Lite is:
Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 31 "ACTION"
The same happens when I have a SQL with a non-reserved name table.
Without the double quotes there is no problem, except of course with
tables such as ACTION.
Any idea why this is happening?
I am not aware of any change to the database that might have caused this.
RBS
Have a Firebird 1.5 database in classic configuration on Windows XP.
As we have at least one table that has a name that is a reserved word (ACTION)
I needed to add double quotes to table names, eg:
select count(rdb$db_key) from "ACTION"
This always used to work fine, but now for some reason this isn't
accepted anymore.
The error message I get in Workbench Lite is:
Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 31 "ACTION"
The same happens when I have a SQL with a non-reserved name table.
Without the double quotes there is no problem, except of course with
tables such as ACTION.
Any idea why this is happening?
I am not aware of any change to the database that might have caused this.
RBS