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