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