> 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
>
>

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.

Neville