4D Doc Center : QR GET SORTS

4D v13.4

QR GET SORTS


QR GET SORTS ( area ; aColumns ; aOrders )

Parameter	Type	Description
area	Longint	Reference of the area
aColumns	Real array	Sorted columns
aOrders	Real array	Sort orders

Description

The QR GET SORTS command populates two arrays:

aColumns
This array includes all the columns that have a sort order.
aOrders
Each element of this array contains the sort orders for the matching column.
- If aOrders{$i} equals 1, the sort order is ascending.
- If aOrders{$i} equals -1, the sort order is descending.

Cross-table mode

In the case of cross-table mode, the resulting arrays cannot have more than two elements since sorts can only be performed on columns (1) and rows (2). (Values for aColumns).

If you pass an invalid area number, the error -9850 will be generated.