Subject | Batch Update of two related tables |
---|---|
Author | nevillerichards |
Post date | 2004-01-10T09:49:32Z |
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?
Neville
[Non-text portions of this message have been removed]
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?
Neville
[Non-text portions of this message have been removed]