Home Datapipelines

Traversing dataset with report modifying field in index

edited August 2012 in Datapipelines

Hi,

I am using Delphi XE with Report Builder 12.03 and ApolloVCL 7.

Apollo is for DBF access.

I have a report (form print), that update 3 fields:
- date of printing
- number of form
- status

To select available forms to print, I filter empty date of printing.
As form is printed, in detailbefore print event, I update the field.
After print 1 form and update date, the report stop printing.
Because the field in index is updated, the record move out of range and
pipeline find eof.

How can I solve this problem?

Should I use in memory dataset to load each record before print, update
them use in memory dataset and traverse those in report?

Best regards

Sergio Melchiori



--

Comments

  • edited August 2012
    Yes, using a ClientDataSet or memory-dataset would be a nice solution.

    Another option might be to use two datasets. One could be a read-only query
    that contains a list of records to print and then the other could be a live
    dataset that you update. You would probably want to link the two.


    -
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.