ASCENDING Function (Record)

Gets or sets the order in which the system searches through a table.


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


Type: Record

The record in the table to search.

Type: Boolean

Specifies the order of the search.

true if the search is to be done in ascending order; otherwise, false if the search is to be done in descending order.
If you do not use this parameter, the function returns the current search order.

Property Value/Return Value

Type: Boolean

The order in which a search will be done.

true if the search will be done in ascending order; otherwise, false.


The following example returns a value that indicates the current search order of the Customer table, to which MyRecord record belongs. The return value is stored in the IsAscending variable and displayed in a message box. In this example, the value Yes is displayed in the message box, which mean the search order is ascending. This is because the SetAscending parameter is not used. This example requires that you create the following variables and text constant in the C/AL Globals window.

Variable name DataType Subtype
MyRecord Record Customer
IsAscending Boolean Not applicable
Text constant name Data type ENU value
Text000 Text Is the current sort order ascending?: %1
IsAscending := MyRecord.ASCENDING;  
MESSAGE(Text000, IsAscending);  


The following example sets the current sort order to descending by setting the SetAscending parameter to false. The value displayed in the message box is No.

IsAscending := MyRecord.ASCENDING(FALSE);  
MESSAGE(Text000, IsAscending);  

See Also

Record Data Type