Subject | Re: [firebird-support] table names with double quotes not recognized |
---|---|
Author | Martijn Tonies |
Post date | 2011-05-10T08:06:40Z |
> Have a Firebird 1.5 database in classic configuration on Windows XP.Did you connect with dialect 3?
> 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.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!