Does that mean it's not possible with this kind of database?

Thanks,

Peter.

________________________________________
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Helen Borrie
Sent: Thursday, 19 April 2007 5:38 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] SQL Question

At 05:00 PM 19/04/2007, you wrote:

>Thanks Helen.
>
>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"

That seems to suggest this is an old dialect 1 database...IB 5.x
maybe? or just a dialect 1 db created by mistake, perhaps...

./heLen