Problem with "dbexpress"

rbuser

Hi:
I use delphi6 with report builder 6.
Use "dbexpress" with "clientdataset, datasetprovider, sqlquery".
Preview takes 18 minutes in unfolding the first page.
Apparently it is because "reportbuilder" hope that executes all "query"
first.
Change to the property "packetrecords" of "clientdataset" to 100, front page
appears to the 5 seconds but soon when requesting other pages the report is
hung or it does not work well.
Try to do it with RAP, but I do not understand like changing to the property
"packetrecords" in the RAP.
I need aid please.
Thanks
Edgar Britez

nardmoseley

1. If you are using external datasets that reside on a form or datamodule,
then you can control the ClientDataSet via Delphi code.

2. If you are using RB's Data workspace, then I recommend modifying the DADE
plug-in for dbExpress. This is located in the unit daDBExpress.pas. The unit
contains a class called TdaChildSQLClientDataSet which is a descendant of
TClientDateSet.
(For an overview of the DADE architecture check out the articles in the DADE
thread of the Tech Tips newsgroup.)

3. In general RB uses standard DataSet methods such as First, Next, Prior,
Last, GetBookmark and GotoBookmark. It requires bi-directional data access.
TClientDataSet in its normal mode supports all of these methods.

We have not tested RB using the PacketRecords feature. As a starting point I
recommend using the external dataset approach mentioned in number 1 and then
if you get that working, proceed to the task mentioned in number 2.