Subject Re: [firebird-support] table names with double quotes not recognized
Author Martijn Tonies
Hello Bart,

> No, dialect 1.

What happens if 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!



> RBS
>
>
>
> On Tue, May 10, 2011 at 9:06 AM, Martijn Tonies
> <m.tonies@...>wrote:
>
>>
>>
>>
>>
>> > 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!
>>
>>
>>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>