Sort()

Previous Next

Sorts all queried records on the column that is currently selected. After sorting, the cursor is in the same record as before sorting. This method toggles between ascending and descending sort order.

You cannot sort columns that are based on a LONGRAW or LONG VARBINARY datatype.

Syntax

Sort([<mode>])

Parameters

mode

· If empty, or if set to TOGGLE, when not all records have been fetched, a question box will be displayed. This question allows you to cancel the operation or to fetch the remaining records before sorting.

 

· If set to FETCHTOGGLE, all records will be fetched without displaying a question box.

Object

Column (Field)