Small and medium business | Business Central, N...

Get the vaule of a table field and display it as a message

(0) Share

Report

Posted on by Community Member Microsoft Employee

hi there,

im finding it hard to find any docs or tutorials about this, i want to get some fields of a table and display them as a message just to get the idea on how it works. I've tired

varText := cctables.FIELD(Name);
MESSAGE(varText);

------

varText := cctables.Value(Name);
MESSAGE(varText);

but doesnt work. Anyone can please link any documentation or share a solution it will be greatfull

Thanks

All responses (2)

Answers (0)

Suggested answer

Marco Mels on at

Like (0)

Report

RE: Get the vaule of a table field and display it as a message

Hello,

Variable name DataType

CustomerRecref RecordRef

MyFieldRef FieldRef

CustomerNo Code

TABLE 2

Text constant name ConstValue

Text000
Customer name has changed to %1.

Documentation()

OnRun()
CustomerNo := '50000';
CustomerRecRef.OPEN(18);
MyFieldRef := CustomerRecRef.FIELD(1);
IF MyFieldRef.ACTIVE THEN BEGIN
MyFieldRef.VALUE(CustomerNo);
MyFieldRef := CustomerRecRef.FIELD(2);
MyFieldRef.VALUE('Contoso');
CustomerRecRef.MODIFY;
MESSAGE(Text000, MyFieldRef.VALUE);
END

Thanks.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Get the vaule of a table field and display it as a message

note: im using NAV 2015 wich c/al editor