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

 AX_EvalServerAOF()
 Evaluates a filter expr to determine its Server AOF optimization level
------------------------------------------------------------------------------

 Syntax

     AX_EvalServerAOF( <cFilterExpr> ) -> numeric

     <cFilterExpr>  Character expression containing the filter expression
     to determine server optimization level

 Returns

     Returns ADS_OPTIMIZED_FULL (1), ADS_OPTIMIZED_PART (2), or
     ADS_OPTIMIZED_NONE (3).  If the operation was unsuccessful, 0 is
     returned, and AX_Error() will return information on why the operation
     failed.

 Description

     AX_EvalServerAOF() evaluates a filter expression to determine its
     Server Advantage Optimized Filter optimization level.

     The optimization for Server AOFs can be one of three levels.  AOFs
     can be fully optimized (ADS_OPTIMIZED_FULL = 1), partially optimized
     (ADS_OPTIMIZED_PART = 2), or not optimized (ADS_OPTIMIZED_NONE = 3).
     For example, the filter expression "lastname == 'Smith' .AND.
     firstname == 'John'" will be fully optimized (ADS_OPTIMIZED_FULL) if
     indexes exist on "lastname" and "firstname".  If an index exists on
     only one of those fields, then the filter will be partially optimized
     (ADS_OPTIMIZED_PART).  If no index exists for either field, then the
     filter will not be optimized (ADS_OPTIMIZED_NONE).

     Note:  Filters created on tables opened with the DBFNTXAX RDD will
     not be optimized.  Only filters created on tables opened by the
     DBFCDXAX RDD will be optimized.

 Example

     USE Accounts INDEX state VIA "DBFCDXAX"

     // Evaluate an expression to determine its optimization level.
     //   This should return ADS_OPTIMIZED_FULL (1).
     ? AX_EvalServerAOF( 'state == "CA"' )