OrderByDirection property: QueryField class
Description
This property returns or sets the order by direction. This property takes a numeric value. The constants are the ASCII codes for space (" ") and "D".
Values are:
| Numeric Value | Constant Value | Description |
|---|---|---|
|
32 |
Code (" ") |
Ascending |
|
68 |
Code("D") |
Descending |
This property is read/write.
Example
The following sets the order by direction to be ascending.
&QueryField.OrderByDirection = Code(" ");The following sets the order by direction to be descending.
&QueryField.OrderByDirection = Code("D");