How to use SETRANGE function in Microsoft Dynamic Navision.

Microsoft Dynamic Navision proves SETRANGE function for the filtering the data from the data table  for retrieving  the data from table you have to use  SETRANGE function

Syntax:
Variable: = Record.SETRANGE(FieldName,FromValue,ToValue);

Example: here if you want to retrieve the customer whose number between 1000 to 2000 then write function like.

          Customer.SETRANGE(‘No.’,’1000’,’2000’);


Here if you pass only 2 parameter in this function then it will take second parameter is same as first parameter. So it’s take both parameter has same values.