C5_DBSETORDER

 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()

 

One response to “C5_DBSETORDER

  1. Pingback: C5_SEEK | Viva Clipper !

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.