This one should be easy but I seem to be suffering from brain fade so I've given it LOADS O' POINTS because I need a quick answer.
I've got a TQuery that selects records for a report based on a boolean field called update being true.
This query is called from TQReport to generate the report.
Now all I want to do is change the boolean field to false in the underlying TTable components after the report has been printed.
I know the logic behind it ie. go through the Query records one by one, and for each instance edit the Table record that has a matching key.
But how ? All these LOCATE, GOTOKEY, EDITKEY syntaxes are just confusing me and sending me around in circles.
Please Please help
I can up the points a bit more if need be
Thanx in advance