Stack Overflow in daSQL.pas
Using Delphi 7 and RB 11.04 Enterprise.We have a report that was designed by
one of customers in our end user app that is erroring when then try and add
a new dataview to it. The report already has 21 dataviews in it, so it's a
fairly complicated report and I think that may be at the root of the
problem. What they do to get the error is the following:
1. Open the Designer and go to the Data tab.
2. Click File/New and choose the Query Designer option.
3. Select a table (doesn't appear to matter which) and then select a couple
of fields.
4. Click OK and the error appears.
Interestingly, if they use the Query Wizard and choose the same table and
fields, the error doesn't happen. I have got a copy of the report and
database here (it's SQL Server 2005 if that makes any difference) and
running it up through Delphi I can see that the error is a stack overflow
that is being thrown from TdaSQL.GetAvailableLinkTypes being called
recursively, in what looks like an infinite loop.
I have attempted to trace through the source code to see if I can narrow
down the cause but with no success. I have attached the RTM file of the
report but how much use that will be with the database I don't know.
Any suggestions or pointers gratefully recieved.
Regards,
Paul
one of customers in our end user app that is erroring when then try and add
a new dataview to it. The report already has 21 dataviews in it, so it's a
fairly complicated report and I think that may be at the root of the
problem. What they do to get the error is the following:
1. Open the Designer and go to the Data tab.
2. Click File/New and choose the Query Designer option.
3. Select a table (doesn't appear to matter which) and then select a couple
of fields.
4. Click OK and the error appears.
Interestingly, if they use the Query Wizard and choose the same table and
fields, the error doesn't happen. I have got a copy of the report and
database here (it's SQL Server 2005 if that makes any difference) and
running it up through Delphi I can see that the error is a stack overflow
that is being thrown from TdaSQL.GetAvailableLinkTypes being called
recursively, in what looks like an infinite loop.
I have attempted to trace through the source code to see if I can narrow
down the cause but with no success. I have attached the RTM file of the
report but how much use that will be with the database I don't know.
Any suggestions or pointers gratefully recieved.
Regards,
Paul
This discussion has been closed.
Comments
For future reference, please send all example to
support@digital-metaphors.com.
Are you able to recreate this issue using one of the End User examples? I
am not able to recreate the issue myself because I do not have your data to
work with. If possible, please give me the steps I can take with one of our
examples or send an example that demonstrates the issue that I can run on my
machine.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com