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 - aofnotfilter() http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 aofNotFilter()
 Logically NOT's the records in a Client Advantage Optimized Filter
------------------------------------------------------------------------------

Syntax

     aofNotFilter( <nHandle1> ) -> logical

     <nHandle>  Handle to an existing filter.

Returns

     Returns .T. if the operation was successful; .F. indicates it failed.
     If aofNotFilter() failed, aofErrorCode() will return information on
     why the function failed.

Description

     aofNotFilter() logically NOT's a user-owned filter so that only those
     records that were not in the user-owned filter are contained in the
     result filter.

     The user-owned filter specified, nHandle1, will contain the result
     of the NOT'd filter.

Example

     // Create user-owned filter for STATE = 'CA'
     nHandle := aofCreateFilter( "State = 'CA'" )

     // Logically NOT the result, creating a filter where STATE != 'CA'
     aofNotFilter( nHandle )

     // Browse those records where state is not 'CA'
     Browse()

     // Free the user-owned filter
     aofFreeFilter( nHandle )


See Also: aofAndFilter() aofOrFilter()

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