Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Syntax on "Sort" method
- Thread starter miho1
- Start date
From ADO HELP
Sort Property
Specifies one or more field names on which the Recordset is sorted, and whether each field is sorted in ascending or descending order.
Settings and Return Values
Sets or returns a String of comma-separated field names to sort on, where each name is a Field in the Recordset, and is optionally followed by a blank and the keyword ASC or DESC, which specifies the field sort order.
Remarks
The data is not physically rearranged, but is simply accessed in the sorted order.
A temporary index will be created for each field specified in the Sort property if the CursorLocation property is set to adUseClient and an index does not already exist.
Setting the Sort property to an empty string will reset the rows to their original order and delete temporary indexes. Existing indexes will not be deleted.
The field cannot be named "ASC" or "DESC" because those names conflict with the keywords ASC and DESC. Give a field with a conflicting name an alias by using the AS keyword in the query that returns the Recordset.
If you look in Windows/Help/ADO210.chm, you will see the complete HELP for ADO.
Sort Property
Specifies one or more field names on which the Recordset is sorted, and whether each field is sorted in ascending or descending order.
Settings and Return Values
Sets or returns a String of comma-separated field names to sort on, where each name is a Field in the Recordset, and is optionally followed by a blank and the keyword ASC or DESC, which specifies the field sort order.
Remarks
The data is not physically rearranged, but is simply accessed in the sorted order.
A temporary index will be created for each field specified in the Sort property if the CursorLocation property is set to adUseClient and an index does not already exist.
Setting the Sort property to an empty string will reset the rows to their original order and delete temporary indexes. Existing indexes will not be deleted.
The field cannot be named "ASC" or "DESC" because those names conflict with the keywords ASC and DESC. Give a field with a conflicting name an alias by using the AS keyword in the query that returns the Recordset.
If you look in Windows/Help/ADO210.chm, you will see the complete HELP for ADO.
manishjoisar
Programmer
The Syntax is
Adodc1.recordset.sort = "<Col1> desc,<Col2>"
Adodc1.recordset.sort = "<Col1> desc,<Col2>"
- Thread starter
- #4
- Status
Similar threads
