Calculating field based on previous and next records

Alan Morrison

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Calculating field based on previous and next records

My application (Oracle 7.3, Delphi C/S 3.02) requires to calculate field
values based on the previous and next records.

Any tips on doing this without using multiple NEXT and PRIOR methods?

I would rather do this in Object Pascal rather than PL/SQL due to the nature
of the calculations performed.

Thanks in advance
Alan

Timo van Noppe

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Calculating field based on previous and next records

Alan Morrison <amorri...@firstengineering.co.uk> schreef in berichtnieuws
7ptmdr$23...@lure.pipex.net...

Quote

> My application (Oracle 7.3, Delphi C/S 3.02) requires to calculate field
> values based on the previous and next records.

> Any tips on doing this without using multiple NEXT and PRIOR methods?

> I would rather do this in Object Pascal rather than PL/SQL due to the
nature
> of the calculations performed.

> Thanks in advance
> Alan

Make a second TTable or TQuery with the same specs.
When on a certain record in the first DataSet, synchronize the second and
skip one for- or backward.

Timo

Other Threads

1. Selecting the next/previous record based on a sort order

2. Sorting record based calculated field?

3. How to sort records based on calculated field?

4. Calculations based on previous record?

5. Lookup field based on calculated field - possible ?

6. Calculate from previous record

7. Help needed: Filtering based on calculated fields

8. Calculating Detail Field Based On Group Sum

9. Calculated Fields (Calculated & Internal Calculated)

10. Repeat (copy) focused field from previous record