AV after adding SQL to query designer!
Using D7 Enterprise build 8.1 with all updates installed and RB 9 on
Win XP Pro SP2. I have a test project that contains a form with a
report, an ADOConnection, an ADODataSet, a DataSource and a DBPipline.
No other code or components have been added to the project. To produce
the AV I do the following.
1) Choose File | Data Settings and specify an ADO connection to my SQL
Server 2000 database.
2) Choose File | New | Query Designer.
3) Click the SQL tab of the designer, right click and choose Edit, then
paste my SQL statement into the memo component.
4) Fill in the name.
5) Close the designer and the dataview is displayed.
6) Attempt to save my project and get the following AV.
Access violation at address 400331AD in module rtl70.bpl. Read of
address 00000014.
If I delete the dataview I can save the project without error. I have
tried several different SQL statements and get different AVs with each.
How can I avoid this AV?
--
.Bill.
Win XP Pro SP2. I have a test project that contains a form with a
report, an ADOConnection, an ADODataSet, a DataSource and a DBPipline.
No other code or components have been added to the project. To produce
the AV I do the following.
1) Choose File | Data Settings and specify an ADO connection to my SQL
Server 2000 database.
2) Choose File | New | Query Designer.
3) Click the SQL tab of the designer, right click and choose Edit, then
paste my SQL statement into the memo component.
4) Fill in the name.
5) Close the designer and the dataview is displayed.
6) Attempt to save my project and get the following AV.
Access violation at address 400331AD in module rtl70.bpl. Read of
address 00000014.
If I delete the dataview I can save the project without error. I have
tried several different SQL statements and get different AVs with each.
How can I avoid this AV?
--
.Bill.
This discussion has been closed.
Comments
1. If you are using DADE, you should not need the ADODataSet, DataSource,
DBPipeline combination any more. All of this will be handled by
ReportBuilder.
2. After removing the above objects, are you able to recreate the issue
using the Northwind sample database on your SQL Server database? If so, let
me know the SQL you are adding and I can try it here on my machine.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Yes, I can reproduce the AV with nothing but an ADOConnection and a
Report on the form using the Northwind database. My test app is
attached. To produce the AV do the following:
Open the form named RptForm and double click the Report component.
Click the Data tab.
Choose File | New | Query Designer from the menu.
Click the SQL tab.
Enter a name.
Right click and choose Edit.
Enter SELECT * FROM CUSTOMERS.
Close the report designer.
Save the project. You should get the AV when you save the project.
--
.Bill.
Yes, I still get the problem with just an ADOConnection and a report
component using SELECT * FROM CUSTOMERS and the Northwind database. I
tried to upload my sample program with detailed instructions to
reproduce the AV but, apparently, your server does not accept posts
with attachments.
--
.Bill.
here.
--
.Bill.
After further research, I found that this is a known design-time ADO bug.
We are unable to reproduce this a runtime making it very difficult to debug
(or even determine whether it is in fact a ReportBuilder issue). Note that
the error only occurs with ADO.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com