4D v14.3

QR GET SORTS

Home

 
Home
4D v14.3
4D Language Reference
Quick Report
QR GET SORTS

QR GET SORTS 


 

QR GET SORTS ( area ; aColumns ; aOrders ) 
Parameter Type   Description
area  Longint in Reference of the area
aColumns  Real array in Sorted columns
aOrders  Real array in Sort orders

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.

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.

 
PROPERTIES 

Product: 4D
Theme: Quick Report
Number: 753

This command modifies the Error system variable

 
HISTORY 

Created: 4D 2003

 
SEE ALSO 

QR SET SORTS

 
ARTICLE USAGE

4D Language Reference ( 4D v12.4)
4D Language Reference ( 4D v11 SQL Release 6)
4D Language Reference ( 4D v14 R3)
4D Language Reference ( 4D v14 R2)
4D Language Reference ( 4D v13.5)
4D Language Reference ( 4D v14.3)
4D Language Reference ( 4D v14 R4)