Thank you for your response. I will give that a try. Wish there
were a simpler solution. Not that a view is difficult I would just
prefer not to use one in this case.

--- In IBObjects@yahoogroups.com, "IB Objects" <jwharton@i...> wrote:
> > Can someone from the IBO team please respond to my problem with
> > KeyLinks and table aliases. This is really causing me problems
and I
> > cannot find any work arounds.
>
> I'm sorry for being a bit quiet today, I've had a really whopper of
a
> headache today for some reason and I gave in and laid down and
snoozed for a
> while.
>
> Jason Wharton
> www.ibobjects.com
>
>
> ----- Original Message -----
> From: "Matt Nielsen" <mnielsen@c...>
> To: <IBObjects@yahoogroups.com>
> Sent: Tuesday, June 10, 2003 7:59 AM
> Subject: [IBO] IBO Team please respond. KeyLinks bug.
>
>
> >
> > Here is the situation again.
> >
> > I have a query:
> >
> > SELECT T1.ID, T2.ID FROM
> > TABLE1 T1
> > LEFT OUTER JOIN TABLE1 T2
> > ON (T1.ID = T2.PARENTID)
> >
> > The key links property should allow me to enter T1.ID but it does
not
> > and only allows TABLE1.ID which when the QuickFetch executes it
> > generates:
> >
> > SELECT T1.ID, T2.ID FROM
> > TABLE1 T1
> > LEFT OUTER JOIN TABLE1 T2
> > ON (T1.ID = T2.PARENTID)
> > WHERE TABLE1.ID = ?BIND_0
> >
> > which of course does not retrieve any records. QuickFetch gets
> > executed when you do a InvalidateBookmark to retrieve/refresh a
> > single record.
>
> Yes, I don't recognize table alias in KeyLinks or any other
properties. This
> is because Firebird/InterBase doesn't recognize them in the values
returned
> in the SQLVAR field descriptors at the API level.
>
> > Please respond with a work around or an indication that this will
be
> > fixed soon. I've already tried RDB$DB_KEY and other type work
> > arounds and becuase the QuickFetch is an internal function it
doesn't
> > call out the any events where I could fix the SQL before the
prepare
> > of the statement. I know I could add my own event to your code in
> > the IBA_BindingCursor.IMP unit in the GetPrepare, but I really
don't
> > want to hack into your code and would prefer a fix.
>
> Using a view is going to be your solution at this point.
>
> I realize this may seem messy for you but if you have self-
referential
> queries it can actually help keep your head from going in too many
circles
> too.
>
> > Thanks,
> >
> > Matt