Record Variables in CU

Business Central/NAV User Forum
1

Hi Experts,

Im new on NAV world and im practicing a litlle in Cde Units but didnt understand one thing… I know that i can create local and global variables of Record type, with a table sub type but i still didnt understand how this variables are populated with the tables records…

On my exercice my record variable comes always uninitialized, and the setrange, set filter does not work…

How does this variables fecth the data from the tables? How can i initialize it in order to be filled with the record tables?

Thkans in advance

Best Regrads

JM

2

HI JM…

I’m guessing your variable is a RECORD?

onRun trigger

CLEAR(TSE);
TSE.SETCURRENTKEY(“Scorecard Processed”,“Staff ID”,Date,“Store No.”);

TSE.SETRANGE(“Scorecard Processed”,FALSE);
TSE.SETRANGE(Date,310111D,060211D);
TSE.SETFILTER(“Store No.”,’<>%1|<>%2|<>%3|<>%4’,‘S080’,‘S098’,‘S114’,‘S123’);
IF TSE.FINDSET(TRUE,TRUE) THEN
REPEAT…

Regards

Paddy