topic Re: SORT in Application Development and Automation Discussions

SORT

radhushankar — Mon, 17 Nov 2008 18:37:58 GMT

Moderator message: please use a more informative subject in futuer

Hi All,

I am having a entries in my table like this

Field1(TYPE C)

12.

When i use SORT ITAB DESCENDING BY FIELD1.I am getting out put like this.

But i want the output like this.

Can any one tell me how to acheive this..

Edited by: Matt on Nov 18, 2008 7:55 AM

Re: SORT

Former Member — Mon, 17 Nov 2008 18:43:25 GMT

declare field1 type as number nd sort descending by field1

Re: SORT

radhushankar — Mon, 17 Nov 2008 18:44:38 GMT

Yeah now i have changed to N.

But still i am facing the same error

Thanks

Re: SORT

radhushankar — Mon, 17 Nov 2008 19:03:41 GMT

Can any one take this up???

Thanks in advance

Re: SORT

Former Member — Mon, 17 Nov 2008 19:06:21 GMT

Now ay it cant be wrong , are you using any other field in addition.

use this statement .

SORT ITAB DESCENDING FIELD1 . ( Dnt add any other field )

Re: SORT

radhushankar — Mon, 17 Nov 2008 19:10:29 GMT

I have done like this SORT INT_UPLOADED DESCENDING BY SEQUENCE.

SEQUENCE IS MY FIELD NAME AND I HAVE DECLARED IT AS

data: sequence(4) type n.

Still i am facing the same error.

Thanks

Re: SORT

Former Member — Mon, 17 Nov 2008 19:15:22 GMT

how can you so sure that its getting sorted wrongly !!!! it cant go wrong . Are you writing it out or r u seeing in debugging mode . If debugging make sure the cursor passes the sort command. As per the above code nothing is wrong , it should work.

Re: SORT

Former Member — Tue, 18 Nov 2008 05:14:54 GMT

Hi,

Use type i (Integer). It will work fine.

If you are using type N. keep value like 09,08,11,12

use FM conversion_exit_alpha_input to convert value 9 to 09

then use sort command