Changes or checks the order in which a search through the table that is referred to by RecordRef will be performed.

[IsAscending :=] RecordRef.ASCENDING([SetAscending])

Parameters

RecordRef

Type: RecordRef

SetAscending

Type: Boolean

Determines the order of the search.

If this parameter is true, it will search in ascending order. If this parameter is false, it will search in descending order. If you do not specify this parameter, it will check the search order.

Property Value/Return Value

Type: Boolean

Specifies the order in which a search will be performed.

Remarks

This function works just like the ASCENDING Function (Record).

Example

The following example opens table 18 (Customer) as a RecordRef variable that is named CustomerRecref. The SETVIEW Function (RecordRef) sets a filter that includes sorting the data in ascending order. The ASCENDING function then checks whether the sort order is ascending, stores the return value in the IsAscending variable and displays Yes in a message box. This example requires that you create the following variables and text constant in the C/AL Globals window.

Variable name DataType

CustomerRecref

RecordRef

IsAscending

Boolean

Text constant name DataType ENU value

Text000

Text

Is the sort order ascending? %1

Copy Code
CustomerRecref.OPEN(18);
CustomerRecref.SETVIEW('SORTING(Name) ORDER(Ascending) WHERE(No.=CONST(10000..20000))');
IsAscending := CustomerRecref.ASCENDING;
MESSAGE(Text000, IsAscending);

Example

The following example opens table 18 (Customer) as a RecordRef variable that is named CustomerRecref. The SETVIEW Function (RecordRef) sets a filter that includes sorting the data in descending order. The ASCENDING function then checks whether the sort order is ascending, stores the return value in the IsAscending variable and displays No in a message box because the sort order is descending. The ASCENDING function changes the sort order to ascending by setting the SetAscending parameter to true. The ASCENDING function checks the sort order again. This time Yes is displayed.

Copy Code
CustomerRecref.OPEN(18);
CustomerRecref.SETVIEW('SORTING(Name) ORDER(Descending) WHERE(No.=CONST(10000..20000))');
IsAscending := CustomerRecref.ASCENDING;
MESSAGE(Text000, IsAscending);
IsAscending := CustomerRecref.ASCENDING(TRUE);
MESSAGE(Text000, IsAscending);

See Also