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

 CHANGED:  INDEX
------------------------------------------------------------------------------

     The new syntax for the INDEX command is:

     INDEX ON <expKey> to <xcIndex> [UNIQUE]
        <scope>
        [FOR <lCondition>]
        [WHILE <lCondition>]
        [[EVAL <lCondition>] [<EVERY <nRecords>]]
        [ASCENDING | DESCENDING]

     The following clauses are new:

     FOR <lCondition> specifies the conditional set of records on which to
     index.

     WHILE <lCondition> specifies another condition that each record
     processed must meet.

     EVAL <lCondition> specifies a condition that is evaluated either for
     each record processed or at the interval specified by the EVERY clause.

     EVERY <nRecords> specifies a numeric expression that modifies how often
     EVAL is evaluated.

     ASCENDING specifies that the index keys be sorted in increasing order of
     value.

     DESCENDING specifies that the index keys be sorted in decreasing order
     of value.