I want to get the new value of field using its no

(0) Share

Report

Posted on by Ziyad Najami

I want to get the field`s Value using its No I tried using Recref and FieldRef but it keeps giving the old value not the modified one
this is the code:

tableextension 50006 "XEE Customer" extends Customer

{

fields

{

modify(Name)

{

trigger OnAfterValidate()

var

myInt: Integer;

begin

WhenFieldIsModifies(Rec.FieldNo(Name), rec."No.");

end;

}

procedure WhenFieldIsModifies(FieldNo: Integer; RecNo: Code[20])

var

MasterCust: Record "XEE Master Customer";

recRF: RecordRef;

fldRef: FieldRef;

Cust: Record customer;

begin

Cust.SetRange("No.", "No.");

if Cust.FindFirst() then begin

// if MasterCust.get(rec."No.") then begin

recRF.OPEN(Cust.RecordId.TableNo, FALSE);

recRF.Get(Cust.RecordId);

recRF.GetTable(Cust);

// recRF.SETTABLE(Cust);

recRF.FINDFIRST;

fldRef := recRF.FIELD(FieldNo);

Message(Format(fldRef));

end;

// end;

end;

}

Can I get the new value onValidate using Recref and FieldRef?

All responses (2)

Answers (0)

Suggested answer

YUN ZHU 73,472 Super User 2024 Season 2 on at

Like (1)

Report

RE: I want to get the new value of field using its no

Hi, try using trigger OnAfterModify(), I tested it and there is no problem.

Hope this helps.

Thanks.

ZHU
Suggested answer

Govinda Kumar 2,203 Super User 2024 Season 1 on at

Like (0)

Report

RE: I want to get the new value of field using its no

If you want to retrieve the current modified name, you can use Rec.Name in your trigger. If you want to get the current record using the field ID, you can refer to the following link for more information, learn.microsoft.com/.../fieldref-value-method