Hi Martijn,

I don't know which Dialect it is using.

How do I tell this?

________________________________________
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Martijn Tonies
Sent: Thursday, 19 April 2007 5:15 PM
To: firebird-support@yahoogroups.com
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
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com