Subject Re: [firebird-support] table names with double quotes not recognized
Author Bart Smissaert
Doesn't seem to be on the local PC. Will see if I can run this later on the
server.
Is it something you can download and install on the local PC?

RBS



On Tue, May 10, 2011 at 10:08 AM, Martijn Tonies <m.tonies@...>wrote:

>
>
> 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
> >
> >
> >
>
>
>


[Non-text portions of this message have been removed]