How to find value from table in Microsoft Dynamics Navision

For  getting the specific value from the table based on some condition, we use setrange and find function, for example we have to find  department name whose  “Dimention code” is “AREA” and it code value is ‘5000’ .

a.       Fist declare Dimention Value table as record.

DimValue

Record

Dimention Value

b.      Now write below code

DimValue.INIT;

DimValue.SETRANGE(“Dimention Code”,’Area’);

DimValue.SETRANGE(Code,’500’);

Message(DimValue.Name);

This above code display name of the department whose code is 500