The
sort
argument indicates the order in which the selected records
should be returned. The sort
argument is a string containing the name of the column
on which you want to sort, preceded by a plus (+) or
minus (-) sign to indicate whether the sort is ascending
or descending. An exception is thrown if the specified
column does not exist in the table. The plus sign is optional: the column name alone within the sort argument will sort the column in ascending order by default. In contrast, the minus sign is required if you wish to sort in descending order.
A series of sort criteria can specified with a comma-delimited string: for example, the string LastName,FirstName will sort the recordset by ascending last name, and secondarily by ascending first name.
