Hi Kelly

I am using 4.8.7

I think you are well out of date :)

I am sure updating will fix that.

Cheers
Rob


bwc3068 wrote:

> I'm not sure if this helps....my version appears to be 4.6Aa
>
> Kelly
>
>
> --- In firebird-support@yahoogroups.com, "bwc3068" <avert@...> wrote:
>
>> Hi Rob--
>>
>> THANKS for the fast reply.
>>
>> I am and I'll do that.
>>
>> Regards
>> Kelly
>>
>> --- In firebird-support@yahoogroups.com, Robert martin <rob@>
>> wrote:
>>
>>> 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
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>
>