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 v6.11 - ax_refreshserveraof() http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 AX_RefreshServerAOF()
 Updates the current Server Advantage Optimized Filter by rebuilding it on
 the server
------------------------------------------------------------------------------

 Syntax

     AX_RefreshServerAOF() -> logical

 Returns

     Returns .T. if the operation was successful, .F. if not.  If the
     operation was unsuccessful, AX_Error() will return information on why
     the operation failed.

 Description

     AX_RefreshServerAOF() rebuilds the current Server Advantage Optimized
     Filter which was created on the Advantage Database Server by an earlier
     call to AX_SetServerAOF().  The AOF will be rebuilt on the server using
     the same filter expression and "resolve" setting.

     AX_RefreshServerAOF() 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.

 Example

     USE Accounts INDEX state VIA "DBFCDXAX"

     // Create an AOF on the server
     AX_SetServerAOF( 'state == "CA"', .F. )

     // List all records where state is California
     LIST state

     // Rebuild the AOF on the server.  This will force our AOF to contain
     //  any new records other users have added where the state is California
     AX_RefreshServerAOF()

     // List all records where state is California
     LIST state


See Also: AX_SetServerAOF()

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