The getSort and setSort methods of the Recordset class indicate or specify one or more field names on which the Recordset is sorted, and whether each field is sorted in ascending or descending order, respectively.
public String getSort();
public void setSort(String criteria);
Sets or returns a string of field names in the Recordset to sort on.
criteria | A string of field names. Each name is separated by a comma, and is optionally followed by a blank and the keyword, ASC, which sorts the field in ascending order, or DESC, which sorts the field in descending order. By default, if no keyword is specified, the field is sorted in ascending order. |