Subject | IBO Team please respond. KeyLinks bug. |
---|---|
Author | Matt Nielsen |
Post date | 2003-06-10T14:59:50Z |
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
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