diff setrange setfilter

dineshkumarcser
dineshkumarcser Member Posts: 34
edited 2011-08-30 in NAV/Navision Classic Client
Diff Beetween Setrange and Setfilter......................?

Comments

  • julkifli33
    julkifli33 Member Posts: 1,092
    dineshkumarcser wrote:
    Diff Beetween Setrange and Setfilter......................?

    Setrange --> Sets a simple filter, such as a single range or a single value, on a field. 
    Record.SETRANGE(Field [,FromValue] [,ToValue])

    Setfilter -->Assigns a filter to a field that you specify. 
    Record.SETFILTER(Field, String, [Value],...)
  • lvanvugt
    lvanvugt Member Posts: 774
    :)

    You're not the first to ask this so you can find the same question (with answers) on this forum. Didi you try that already?

    Have, for example, a look here: http://www.mibuso.com/forum/viewtopic.php?f=23&t=41518&hilit=SETRANGE+SETFILTER
    Luc van Vugt, fluxxus.nl
    Never stop learning
    Van Vugt's dynamiXs
    Dutch Dynamics Community
  • mabl4367
    mabl4367 Member Posts: 143
    SETRANGE is uset to create simple filters of type:
    <Field>=<Some value> or
    <Some lesser value> <= <Field> <= <Some greater value>

    Only filters in continous RANGES can be created with SETRANGE.

    SETFILTER on the other hand is used to create more komplex filters like:
    <Field> = <Some value> or <Field> <= <Some other value>

    Have a look at the helpsections on the two functions for more details.
  • kriki
    kriki Member, Moderator Posts: 9,121
    see also http://www.mibuso.com/howtoinfo.asp?FileID=22
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories