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
> >
> >
> >
> >
> >
>