Speed problems with updating new value to Query detail dataset (cached updates)

Darko Hozjan

Delphi Developer

Fri, 22 Mar 2002 03:00:00 GMT

Speed problems with updating new value to Query detail dataset (cached updates)

Hello,

I have speed problem with updating new value to specific record
in paradox tables.

I have master table and detail table. I'm working with cached updates and
I'm using FILTER for showing detail records.

So on detail recordset I have some code on CALCFIELDS, which
calculates some calculated fields.

now....

When I want to change some value on detail records, operation for
updateing takes to long.....Even if I have only five detail records..

Code loks like :

dm1.Q_POSTAVKA.First;
while not dm1.Q_POSTAVKA.Eof do
begin
dm1.Q_POSTAVKA.Edit;
dm1.Q_POSTAVKARABAT.Value:=odstotek;
dm1.Q_POSTAVKA.Next;
end;

Q_POSTAVKA is detail query recordset...

This iteration takes to long. I don't know why...

Can anybody help me ?

thanks DARKO

Grega Lobod

Delphi Developer

Fri, 22 Mar 2002 03:00:00 GMT

Re:Speed problems with updating new value to Query detail dataset (cached updates)

Put a break point into while and check, how many times your while goes
through. Is it really 5 times even if you have 5 detail records.
Anyway, you should also see, if you go step by step through code with F8,
where this wile is takeing so long.

Grega!

Quote

Darko Hozjan wrote:
> Hello,

> I have speed problem with updating new value to specific record
> in paradox tables.

> I have master table and detail table. I'm working with cached updates and
> I'm using FILTER for showing detail records.

> So on detail recordset I have some code on CALCFIELDS, which
> calculates some calculated fields.

> now....

> When I want to change some value on detail records, operation for
> updateing takes to long.....Even if I have only five detail records..

> Code loks like :

> dm1.Q_POSTAVKA.First;
> while not dm1.Q_POSTAVKA.Eof do
> begin
> dm1.Q_POSTAVKA.Edit;
> dm1.Q_POSTAVKARABAT.Value:=odstotek;
> dm1.Q_POSTAVKA.Next;
> end;

> Q_POSTAVKA is detail query recordset...

> This iteration takes to long. I don't know why...

> Can anybody help me ?

> thanks DARKO

Other Threads

1. Master-Detail Query w/Cached Updates requeries Detail when updating single fields in Master

2. Cached updates, altering dataset values

3. cached updates and master/detail queries

4. Cached updates - one query but several tables to update

5. Cached Updates QUESTION: Sorting table of updated and non-updated records

6. Cached Updates are dead - long live cached updates?

7. Master detail detail, cached updates, and insert/delete

8. Cached updates Master/Detail problem

9. master/detail cached update problem

10. Cached Updates with Master-Detail problem