how to SETRANGE integer value?

hai all… how to setrange integer value?

like this PurchaseLine.SETRANGE(PurchaseLine.“Qty To Receive”,> 0);

→ it doesn’t work…

i want to filter the items that have qty to receive is greater than 0

thanx for the answer

Use SETFILTER

PurchaseLine.SETFILTER(PurchaseLine.“Qty To Receive”, ‘>0’);

wow !! it works !!!

thanx nuno !! :slight_smile:

The difference between SETFILTER and SETRANGE is that with FILTER the parameter is a filter string, and with RANGE the parameters are from and to values. Go into the C/SIDE reference guide (in the help menu) and search for the two, there are excellent explanations in there.