Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Is there any Possibili...

Is there any Possibility to set ascending and descending order to record in table through code?

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi All,

Is there any Possibility to set ascending and descending order to record in table through code i know is there Ascending Function but it is workable to table primary Key but i want to set ascending order for other field in table.

if i wrote like this RecordVariable.Ascending; this done as per recordvariable primary key value?

but i want other field that is integer field.

How can i done this through code?

Regards,

Ramesh.

*This post is locked for comments

All responses (3)

Answers (3)

Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Is there any Possibility to set ascending and descending order to record in table through code?

yes suresh,

i used SETCURRENTKEY and after that i used this Ascending Function

as

RecordVariable.SETCURRENTKEY(Field);

RecordVariable.ASCENDING;

It works Fine.
Verified answer

Suresh Kulla 44,614 on at

Like (0)

Report

RE: Is there any Possibility to set ascending and descending order to record in table through code?

You can use ASCENDING function on any field, you just need to create a key for that field and then use SETCURRENTKEY function on the field before you use ASCENDING on that field.
Verified answer

keoma 32,675 on at

Like (0)

Report

RE: Is there any Possibility to set ascending and descending order to record in table through code?

create if needed a new key.

then use setcurrentkey.