Table of Contents

SORTED event

Description

This event takes the same parameters as passed to the SORT method. This event is fired before any sorting takes place, thereby giving you the chance to modify the criteria or options, or even prevent it by using the Set_EventStatus() function. All event script and QuickEvent handlers are processed before sorting.

Applies To

EditTable

Syntax

Parameters

Parameters are as follows.

ParameterDescription
SortCriteria<0,1> @svm'd list of column numbers to sort by
<0,2> @svm'd list of sorting directions/justifications for each column passed in field <0,1>. Available values are:

0 - Descending Left
1 - Ascending Left
2 - Descending Right
3 - Ascending Right
<0,3> @svm'd list of ICONV patterns used to convert the column data to its internal format before the sort takes place.

The default ICONV pattern used for sorting a column is taken from it's VALID property. This means that you can flag a column as a date (e.g. "DE") in the Form Designer, and have it sort properly in a numeric fashion without any extra coding needed.
SortOptions<1> If TRUE$ then perform a trim operation before the sort takes place, or FASLSE$ to prevent the trim. If this field is null then the SORTTRIM property is used to decide if a trim operation takes place.