The SETRANGE procedure 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 procedure removes any filters that were previously set for the defined field (filtering procedures 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 procedure in code are as follows:
- Clear the filters on Item.No.:
Item.SETRANGE("No.");
- Filter to get only items with No. from 1300 through 1400:
Item.SETRANGE("No.",'1300','1400');
- Alternatively, you can use the variable values from LowVal through HiVal:
Item.SETRANGE("No.",LowVal...