Outer Joins for Sybase ASA
Hello,
First the versions that I am using:
Delphi 6 (with update pack 2)
Sybase 7.0.4.3472
ReportBuilder Enterprise 5.0
Dade Plug-in for ODBCExpress (5.0) by By Grant Dunoon (11 Oct 2000)
Problem:
We have an end-user reporting solution where, it seems like, that the
reports with LEFT OUTER and RIGHT OUTER joins are not working correctly.
Actually, if I am not mistaken then none of the reports with any kind of
OUTER join are working.
If we look at the generated SQL then we don't see the proper operators that
we should be seeing for such kinds of joins. For example, for LEFT OUTER
join, we should see "*=" and not just "=".
The databasetype property is set to Sybase ASA. If I step through the source
code, I can see that the JOINTYPE for the JOINTABLE object always stays at
"dajtOuter" even though I can verify that the JOINTYPE should be, for
example, "dajtLeftOuter". Thus, it never goes to the code that would change
the operator correctly. While we are on this, I also noticed a related
problem in that that there is no check for the Sybase ASA itself. There is a
check for Sybase ASE but noting for ASA. Thought I should mention that
anyhow.
I even tried to hook into the TdaSQL.OnAddWhereClauseText event but it looks
like that there is an inner object of MagicSQL that is doing the actual
generation and thus I am unable to get to it - no matter how hard I try. The
idea was to change the SQL at run-time using this event handler but so far
no luck.
I am pretty sure that someone must have run into this kind of problem so
please share some tips here if you have some.
Thanks and Have a great day,
AZ.
(If you think that this may not be the right NG for this kind of problem
then please let me know where to post it)
First the versions that I am using:
Delphi 6 (with update pack 2)
Sybase 7.0.4.3472
ReportBuilder Enterprise 5.0
Dade Plug-in for ODBCExpress (5.0) by By Grant Dunoon (11 Oct 2000)
Problem:
We have an end-user reporting solution where, it seems like, that the
reports with LEFT OUTER and RIGHT OUTER joins are not working correctly.
Actually, if I am not mistaken then none of the reports with any kind of
OUTER join are working.
If we look at the generated SQL then we don't see the proper operators that
we should be seeing for such kinds of joins. For example, for LEFT OUTER
join, we should see "*=" and not just "=".
The databasetype property is set to Sybase ASA. If I step through the source
code, I can see that the JOINTYPE for the JOINTABLE object always stays at
"dajtOuter" even though I can verify that the JOINTYPE should be, for
example, "dajtLeftOuter". Thus, it never goes to the code that would change
the operator correctly. While we are on this, I also noticed a related
problem in that that there is no check for the Sybase ASA itself. There is a
check for Sybase ASE but noting for ASA. Thought I should mention that
anyhow.
I even tried to hook into the TdaSQL.OnAddWhereClauseText event but it looks
like that there is an inner object of MagicSQL that is doing the actual
generation and thus I am unable to get to it - no matter how hard I try. The
idea was to change the SQL at run-time using this event handler but so far
no luck.
I am pretty sure that someone must have run into this kind of problem so
please share some tips here if you have some.
Thanks and Have a great day,
AZ.
(If you think that this may not be the right NG for this kind of problem
then please let me know where to post it)
This discussion has been closed.
Comments
You mention you are using RB Enterprise 5.0. Have you tested with the latest
version of RB 7.03? There have been significant enhancements to DADE since
RB 5.0 so you may wish to give the latest version a try to see if it
corrects the issue. You can download a trial edition to test from our
website www.digital-metaphors.com
Cheers,
Jim Bennett
Digital Metaphors
http://www.digital-metaphors.com
info@digital-metaphors.com