|
<< Click to Display Table of Contents >> Navigation: ThinBASIC Modules > ADODB > ADODB Module Classes > ADODB_Recordset > ADODB_Recordset Properties > <ADODB_Recordset>.Sort |
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"