DBSETORDER() Set the controlling order ------------------------------------------------------------------------------ Syntax DBSETORDER(<nOrderNum>) --> NIL Arguments <nOrderNum> is a numeric value that specifies which of the active indexes is to be the controlling index. Returns DBSETORDER() always returns NIL. Description DBSETORDER() controls which of the current work area's active indexes is the controlling index. The controlling index is the index which determines the logical order of records in the work area. Active indexes are numbered from 1 to the number of active indexes, based on the order in which the indexes were opened. <nOrderNum> specifies the number of the desired index. DBSETORDER() performs the same function as the standard SET ORDER command. For more information, refer to the SET ORDER command. Notes . Setting order to zero: Setting order to zero causes the work area to be accessed in natural (record number) order. Only the logical order of the records is affected; any open indexes continue to be active and are properly maintained. Examples . This example sets the second named index, Age, as the controlling index: USE Employee NEW SET INDEX TO Name, Age DBSETORDER(2) Files Library is CLIPPER.LIB.
See Also: DBCLEARIND() DBCREATEIND() DBREINDEX() DBSETINDEX()
Pingback: C5_SEEK | Viva Clipper !