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