Subject | Re: [IBO] Batch Update of two related tables |
---|---|
Author | Helen Borrie |
Post date | 2004-01-10T11:36:10Z |
At 09:49 AM 10/01/2004 +0000, you wrote:
Helen
>Two related tables contain beween them about 1 million records. (About 4Why do you want to use query components for a batch update?
>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?
Helen