Subject Re: Batch Update of two related tables
Author Marco Menardi
--- In IBObjects@yahoogroups.com, "nevillerichards" <neville@m...> wrote:
> > 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

Have a look at IBO Tech Sheets:
http://www.ibobjects.com/TechInfo.html
also some Client/Server concepts are explained, and you can have an
idea about what IBO native components can do for you that BDE and
TDataset had never been capable of ;)
regards
Marco Menardi