Specifies an ascending or descending order for the controlling index tag specified by the Order property of a Cursor object. Read/write at design time and run time.
Note: |
---|
OrderDirection is disregarded when the cursor's Order property is empty. |
Cursor.OrderDirection [= nValue] |
Return Value
- nValue
-
Specifies a value that determines the order for a cursor index. The following table lists the values for nValue.
nValue Description 0
Base index order on how the index file or tag is defined, for example, using the INDEX command. (Default)
1
Set index order to ascending.
2
Set index order to descending.
Remarks
Applies To: Cursor
Setting OrderDirection to ascending or descending order is equivalent to calling the SET ORDER command with the ASCENDING or DESCENDING keyword. However, you can change the controlling index and its order for a cursor without changing the OrderDirection and Order properties. Changes to the OrderDirection property do not affect the index order until the Order property is also changed.