Is the current record the last one?

pedroccda

Hi, I want to undertstand how I can know when the current record I'm working with is the last one (or if there are no other record after the current)? Is there any function to call to know it or a trigger that is fired automatically at last record (or end of record).

SteveO

If NEXT = 0 then you know that the record you are on is the last one. However, if next <> 0 then it will go on to the next record and thereby change the current record that you are on.

eg.
IF FIND('-') THEN
REPEAT
something;
UNTIL NEXT = 0;

The above is code used to loop through a table and perform some action.

kine

  OnAfterGetCurrRecord()

  TmpRec.COPY(Rec);
  if TmpRec.NEXT=0 then begin
    some code for last entry...
  end;