Please enable JavaScript to view this site.

thinBasic Help Manual

* * HELP & MANUAL PREMIUM PACK 4 DEMO VERSION * *

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"

Created with Help+Manual 8 and styled with Premium Pack Version 4 © by EC Software