Hi

Are you using IBObjects? If so I believe this is a problem with one of
the older releases of the components. If you download the latest
version this issue should disappear.

Rob

bwc3068 wrote:

> Hi--
>
> In FB 1.5 the below SQL worked fine.
>
> Select O.OwnerName, O.UniqueKey from Owners O
> Order By O.OwnerName
>
> I just installed FB 2.1 and when that query is executed, I get an
> error: ISC Error, SQL error code =-206 column unknown Owners.DB_KEY.
>
> If I remove the table alias, it's fine
> (ie.
> Select OwnerName, UniqueKey from Owners
> Order By OwnerName
> )
>
> OR if i use Select O.*
>
> This would be fine for this 1 query but I have a large number of much
> more complicated queries with joins, etc. that I need to define the
> table.
>
> Please help!
>
> Thanks
> Kelly
>
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>
>