Subject Re: [IBO] Batch Update of two related tables
Author nevillerichards
> 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
> >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
There are three parts to the process - selection of the correct subset of
records, complex calculations (in Delphi), finally update of the records in
the table. Basically, both I and the application are refugees from BDE
Paradox. I am somewhat limited in my knowledge of the slicker alternatives
available in IBO.