Hello Bart,

What happens if you connect with ISQL (command line tool by Firebird)
with dialect 1 and use the double quotes?

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!

> Seems to make no difference, but database is dialect 1 and it seems
> connection reverts back to that.
> Not sure I actually have connected with dialect 3.
>
> RBS
>
> On Tue, May 10, 2011 at 9:43 AM, Martijn Tonies
> <m.tonies@...>wrote:
>
>>
>>
>> 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
>> >
>> >
>> >
>> >
>>
>>
>>
>
>
> [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
>
>
>