Programming Microsoft Dynamics NAV - Fifth Edition

SETRANGE function

The SETRANGE function provides the ability to set a simple range filter on a field. The SETRANGE syntax is as follows:

Record.SETRANGE(FieldName [,From-Value] [,To-Value]);

Prior to applying its range filter, the SETRANGE function removes any filters that were previously set for the defined field (filtering functions are defined in more detail in the next chapter). If SETRANGE is executed with only one value, that one value will act as both the From and To values. If SETRANGE is executed without any From or To values, it will clear the filters on the field. This is a common use of SETRANGE. Some examples of the SETRANGE function in code are as follows:

• Clear the filters on Item.No:

        Item.SETRANGE("No.");

• Filter to ...