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 <=
next(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
Programmer
dhor...@yorkna.com

 

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

--

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

Other Threads