Navigation:  ThinBASIC Modules > ADODB > ADODB Module Classes > ADODB_Recordset > ADODB_Recordset Properties >

<ADODB_Recordset>.Sort

Previous pageReturn to chapter overviewNext page

 

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"