Re: [Navision-Knowledge-Village] Difference Between SETRANGE and SETFILTER

[robert musau]

I think they are almost similar in many ways. The difference is that with SETFILTER, you can specify a range eg 
 
SETFILTER("Result Value",'%1..%2','a','z');
 
with SETRANGE statement, you cannot give a range of values. You actually know what you want exactly eg
 
SETRANGE("Result Value",'a');
 
The above will work. However, the following will not work, and will give an error.
 
SETRANGE("Result Value",'%1..%2','a','z');
 
Regards,
 Robert Musau
madhan mohan <[EMAIL PROTECTED]> wrote:

Hi all,
 
     I like to know the difference between SETRANGE and SETFILTER....and which is faster and why. Can anybody help me.
 
Thank U
 
Regards
G. Madhan


Start your day with Yahoo! - make it your home page 
		How much free photo storage do you get? Store your holiday snaps for FREE with Yahoo! Photos. Get Yahoo! 
Photos





Sharing the knowledge on Navision.





  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "Navision-Knowledge-Village" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.