Trevor,

> The following simple queries cause an error in the latest 2.1.1
> release of Firebird:
>
> SELECT * FROM RAORDERS O
> WHERE O.ORDERID = 1
>
> The error returned includes the text "Unknown column db_key".
>
> The database is dialect 1, and has been restored by the current
> version of gbak.
>
> Other similar queries fail when a table alias is used without a join
> to another table. I haven't proved that this is always the case, as
> most of our non-join queries don't use aliases!
>
> So this works:
> SELECT * FROM RAORDERS O
> INNER JOIN RACUSTOMERS C ON C.CUSTOMERID = O.CUSTOMERID
> WHERE O.ORDERID = 1
>
> We connect to the database using Delphi 2007 and the BDE (sorry!) but
> the same query fails when entered directly into IBOConsole.

The error is with IBOConsole, not with Firebird!

Please update the application or contact the appropriate IBO support
list to resolve the issue.


Sean