Board index » delphi » Comparing one record with next record

Comparing one record with next record

Is there a way to compar values in one record with the value in the next
record of a database.  For example I want to do something like this:

while (dm.tblteqhistory.fieldbyname('Eq-job-nbr').AsString <=

I have not been able to find anything like that within Delphi 2.0 help.

Thanks for any help.

Dwaine Horton
York National Accounts


Re:Comparing one record with next record

Use a second TTable. Call the GoToCurrent method to position the second
TTable to the same record as the first TTable then call Next to move it to
the next record.



Bill Todd - TeamB
(TeamB cannot respond to email questions. To contact me
 for any other reason remove nospam from my address.)

Other Threads