[<<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