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

 REFRESH FILTER
 Rebuilds a Client Advantage Optimized Filter
------------------------------------------------------------------------------

 Syntax

     REFRESH FILTER

 Description

     REFRESH FILTER rebuilds the current Client Advantage Optimized
     Filter which was created on the Advantage Client by an earlier
     call to aofSetFilter().  The AOF will be rebuilt on the client using
     the same filter expression.

     The REFRESH FILTER command is useful if it is known if record updates
     have been made that affect their inclusion in the filter.  AOFs are a
     snapshot of the table.  Record updates made after the AOF is created
     are not reflected in the AOF.  It may also make sense to call this
     function if an index that could affect the optimization level of the
     AOF has been opened or created since the original AOF was created.

     Note:  REFRESH FILTER is a Client Advantage Optimized Filter command.
     The command is only available if you link the Client Advantage Optimized
     Filter library, AOF.LIB, into your application and you #include the
     AOF.CH header file in your source code.

 Example

     // Must include AOF.CH in your source code to make the REFRESH FILTER
     //   command available.
     #include "AOF.CH"

     // Assume indexes have single field key expressions
     USE names SHARED INDEX name, salary, state, date VIA "DBFCDXAX"

     // Set filter (this command pre-compiles to call aofSetFilter())
     SET FILTER TO state = "CA"

     // Activate filter
     GO TOP

     WHILE LastKey() != 27
        // Browse the filtered records
        Browse()

        // Rebuild the AOF
        REFRESH FILTER
     END