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

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (3)

Answers (3)

Verified answer

keoma 32,729 on at

Like (0)

Report

create if needed a new key.

then use setcurrentkey.

Was this reply helpful? Yes No
Verified answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

yes suresh,

i used SETCURRENTKEY and after that i used this Ascending Function

as

RecordVariable.SETCURRENTKEY(Field);

RecordVariable.ASCENDING;

It works Fine.

Was this reply helpful? Yes No