Click above to get retro games delivered to your door ever month!

  m6_SetFilter():

  Purpose:  Used to filter out records in a database that to do not match
            a specific condition.

   Syntax:  m6_SetFilter( <bFilter>, <cFilter>, <lNoOptimize> )

    Where:  <bFilter>     = Code block containing filter condition
            <cFilter>     = Filter text ( used by Mach SIx )
            <lNoOptimize> = Toggles off automatic optimization

    Note:   SET ORDER TO 0.  Because Mach SIx internally caches filtered
            records in natural record order optimal filter performance will
            be achieved with SET ORDER TO 0.

  Returns:  NIL


  Example:   #include "DBFSIX.CH"
             #include "MACHSIX.CH"

             #define OPTIMIZE_OFF  .T.

             Use Accounts via "DBFSIX"

             bFilter := {|| state == "CA" }
             cFilter := 'state == "CA"'

             //...............................................set the filter
             m6_SetFilter( bFilter, cFilter )
             go top

             //..........................check the filter optimization level
             ? m6_IsFilter()  // 2

             //............................set filter with optimization off
             m6_SetFilter( bFilter, cFilter, OPTIMIZE_OFF )

             //.........................check the filter optimization level
             ? m6_IsFilter()  // 0