Subject | Re: [IBO] Batch Update of two related tables |
---|---|
Author | Jason Wharton |
Post date | 2004-01-22T14:50:20Z |
> Two related tables contain beween them aboutI recommend you use stored procedures as much as possible for this type of
> 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?
thing.
Jason Wharton
www.ibobjects.com