Subject RE: [firebird-support] SQL Question
Author Peter Dennis
Hi Martijn,

I don't know which Dialect it is using.

How do I tell this?

[] On Behalf Of Martijn Tonies
Sent: Thursday, 19 April 2007 5:15 PM
Subject: Re: [firebird-support] SQL Question

Hi Peter,

> Sorry about the non-plain text message before.
> How do i do this kind of query when using the Firebird ISQL Tool?
> I get this error for the following query:
> SQL> select subu_name As "Suburb Name" from suburb where subu_id = 2000;
> Statement failed, SQLCODE = -104
> Dynamic SQL Error
> -SQL error code = -104
> -Token unknown - line 1, column 21
> -"Suburb Name"

Is your database a "dialect 3" database?

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
My thoughts:
Database development questions? Check the forum!