[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 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.


This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson