Subject | Re: [firebird-support] table names with double quotes not recognized |
---|---|
Author | Bart Smissaert |
Post date | 2011-05-10T09:21:04Z |
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
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]