Subject Re: [IBO] Batch Update of two related tables
Author Helen Borrie
At 09:49 AM 10/01/2004 +0000, you wrote:
>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?

Why do you want to use query components for a batch update?

Helen