Sort method: QueryDBRecordField collection
Syntax
Sort(SortCriteria)Description
Use the Sort method to sort the fields within the QueryDBRecordField collection, based on the sort criteria specified with the method.
Parameters
| Parameter | Description |
|---|---|
|
SortCriteria |
Specify the sort order for the list. This parameter can take either a constant or numeric value. See below. |
The values for OutputFormat can be as follows:
| Numeric Value | Constant Value | Description |
|---|---|---|
|
1 |
%Query_SortNameAsc |
Sort database fields in ascending order based on field name. |
|
2 |
%Query_SortNameDesc |
Sort database fields in descending order based on field name. |
|
3 |
%Query_SoftFldNumAsc |
Sort database fields in ascending order based on field number. |
|
4 |
%Query_SortFldNumDesc |
Sort database fields in descending order based on field number. |
Returns
0