How to change previous record?

NAVision

Hi
I want to change previous record in table (to set ending if date in current record is today). I try this code:

OnAfterGetRecord()
IF "Date From"=TODAY THEN BEGIN
Rec.NEXT:=-1;
Rec."Date To":=TODAY-1;
END;

zohaibu95@hotmail.com

You can access previous record by doing

Rec.NEXT(-1); //it will return you the previous record.

General syntax is Rec.NEXT(Steps);


please verify my answer, if it was helpful for you. thanks.

RockWithNAV

Why dint you used MODIFY at last??

Kishorm

You should do it on a copy of the record, not on Rec itself. So create a variable called Rec2 for the same table and then try the following code...

OnAfterGetRecord()
IF "Date From" = TODAY THEN BEGIN
  Rec2.COPY(Rec);
  IF Rec2.NEXT(-1) THEN BEGIN
    Rec2."Date To" := TODAY-1;
    Rec2.MODIFY;
  END;
END;

EDIT: Oops - @jreynolds is correct, code amended accordingly

jreynolds

Be careful using assignment (:=) to copy Rec to Rec2. This will only copy the values of the fields in Rec to Rec2; it will not copy settings for filters and the current key. Therefore, Rec.NEXT(-1) and Rec2.NEXT(-1) will not necessarily be the same record. It's better to use COPY so that filters and key settings are copied as well.