Subject | FB 1.5 to 2.1 question |
---|---|
Author | bwc3068 |
Post date | 2008-09-11T22:00:33Z |
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
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