This documentation was styled with a demo skin from the Premium Pack 4 add-on for Help & Manual. The contents of the skin are encrypted and not configurable. You can only publish HM projects with this skin. You cannot edit it or change it.
This version is copyright and may only be used for local testing purposes. It may not be distributed.
Please purchase the full version of the Premium Pack to get the configurable skins and remove this notice. The package will also include the Toolbox configuration utility for Premium Pack skins.
Description
Sets or returns a string value that specifies the field names in the ADODB_Recordset to sort on.
Syntax
GET
s = <ADODB_Recordset>.Sort
SET
<ADODB_Recordset>.Sort = sSort
Returns
String
Parameters
Name |
Type |
Optional |
Meaning |
sSort |
String |
No |
Each field name must be separated by a comma. To choose the sort order, you can specify ASC (ascending order), or DESC (descending order) after the field name. Default is ASC. |
Remarks
Restrictions
See also
Examples
rs.Sort = "CompanyName,ContactName,[Ship Address]"
rs.Sort = "CompanyName DESC,ContactName"