Subject | Re: Batch Update of two related tables |
---|---|
Author | Marco Menardi |
Post date | 2004-01-11T09:00:24Z |
--- In IBObjects@yahoogroups.com, "nevillerichards" <neville@m...> wrote:
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
> > At 09:49 AM 10/01/2004 +0000, you wrote:(About 4
> > >Two related tables contain beween them about 1 million records.
> > >detail to 1 master)and detail
> > >
> > >Periodically, it is necessary to update a sizeable and well-defined
> subset
> > >of both tables, re-calculating many column values. The master
> > >calculations are interdependent.through
> > >
> > >Can I use a couple of TIBOQuery components to synchronously work
> > >the required records in both tables, updating as I go?subset of
> >
> > Why do you want to use query components for a batch update?
> >
> > Helen
> >
> >
> There are three parts to the process - selection of the correct
> records, complex calculations (in Delphi), finally update of therecords in
> the table. Basically, both I and the application are refugees from BDEalternatives
> Paradox. I am somewhat limited in my knowledge of the slicker
> available in IBO.Have a look at IBO Tech Sheets:
>
> Neville
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