Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- Advantage CA-Clipper Guide v5.5 - aofrefilter() http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 aofReFilter()
 Logically AND's the system-owned Client Advantage Optimized Filter with the
 specified condition
------------------------------------------------------------------------------

Syntax

     aofReFilter( <cCond> ) -> NIL

     <cCond>  The additional conditional character expression which
     records should meet. This condition is AND'd with the current
     system-owned filter.

Returns

     NIL

Description

     The aofReFilter() function is very similar to aofSetFilter(), but it
     further filters previously selected records. The <cCond> condition
     is simply AND'd with the previously existing system-owned filter
     (if one exists).

     The advantage of using this function is that none of the work done
     in previously selecting the records is repeated.

     If the resulting filter from aofReFilter() is not fully optimized,
     and the "Auto Resolve" setting is ON (see aofSetAutoResolve() for more
     information), then the filter will be automatically resolved into
     a fully-optimized filter.

Example

     // Create a system-owned filter where state = 'CA'
     aofSetFilter( "state = 'CA'" )

     ? aofCountRecords()     // 78

     // Further filter our system-owned filter by only those records
     // where age < 35
     aofReFilter( "age < 35" )

     ? aofCountRecords()     // 23


See Also: aofSetFilter() aofAndFilter() aofGetAutoResolve()

Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson