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