questions about ADO and Delphi IDE

From: Whitney (myado_at_hotmail.com)
Date: 11/19/03 

Date: 18 Nov 2003 23:12:16 -0700

When i use ado to access the database, i am stuck in some bugs. Has anybody encountered same problems and could anybody give me some suggestions?

1.When i use a TADOQuery to retrieve data, I set the filtered property as false and left the filter property empty. But when running, an exception was thrown out with message "filter property cannot be used for detail tables".

2.I have a calculated field which gives out the total cost. The problem is that the first row always gives $0, while the other rows give correct value.

3.I have a data module in my application which contains all the data-related components. Everytime when I tried to open the datamodule file from the IDE, i was told "couldnot load a form that has itself as an ancestor". I have to load the datamodule.dfm first and use "view as form" to convert it into datamodule.pas. What is the problem from? How could I fix it?

Thanks in advance for any help!