Subject IBO Team please respond. KeyLinks bug.
Author Matt Nielsen
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.

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.

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.

Thanks,

Matt