Subject Batch Update of two related tables
Author nevillerichards
Two related tables contain beween them about 1 million records. (About 4 detail to 1 master)

Periodically, it is necessary to update a sizeable and well-defined subset of both tables, re-calculating many column values. The master and detail calculations are interdependent.

Can I use a couple of TIBOQuery components to synchronously work through the required records in both tables, updating as I go?


[Non-text portions of this message have been removed]