Subject FB 1.5 to 2.1 question
Author bwc3068
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