Traversing dataset with report modifying field in index
edited August 2012 in Datapipelines
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
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?
This discussion has been closed.
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.