[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 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()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson