SETRANGE ,SETFILTER AND GET FUNCTIONS
Difference between SETRANGE and SETFILTER: 1) When we apply filter using SETRANGE it directly applies filter with the given value where as SETFILTER converts the given value into text and then applies filter. 2) By using SETRANGE we can not filter multiple values at a time where as in SETFILTER we can filter multiple values at a time. (But using both SETFILTER and SETRANGE we can filter a range of values). Ex: Customer.SETRANGE (“NO.”,’10000’); In this case we can filter only customer no. 10000. Customer.SETFILTER (“No.”,’%1%2’,’10000’,’20000.); Here we can filter customer No.10000 as well as 20000. 3) By using SETRANGE we can not avoid one single record or multiple records where as by using SETFILTER we can. Ex: Customer.SETFILTER (“No.”,’ %’,’10000’); Note: In all examples Customer is the Record type of variable and Var1, Var2, Var3…. are the variables. SETRANGE: 1) When we are directly supplying value through a variable. Customer.SETRANGE (“No.”,’10000...