Subject Re: [IBO] Batch Update of two related tables
Author Jason Wharton
> 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?

I recommend you use stored procedures as much as possible for this type of
thing.

Jason Wharton
www.ibobjects.com