Subject Re: [firebird-support] table names with double quotes not recognized
Author Martijn Tonies
> 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.

Did you connect with dialect 3?

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!