Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Solution for avoiding sort

Former Member
0 Likes
1,044

Hi All,

I have created a table where i want to maintain temperatures in required order. I want to retain the order

of the data in which it is been created but by default the values are getting sorted in ascending order.

Is there any provision to avoid the sorting by default.

Thanks in Advance,

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
979

Hi

But where have u the default sorting?

Max

6 REPLIES 6
Read only

Former Member
0 Likes
980

Hi

But where have u the default sorting?

Max

Read only

0 Likes
979

Hi Max,

Its a transparant table where i want to maintain the data. data is automatically saved in sorted order in Data Dictionary. Please help.

Read only

0 Likes
979

hi,

if all the fields of the table are numeric data types (i.e, i,p,f) then the table won't be sorted

regards

sarves

Read only

0 Likes
979

Hi

So you're speaking about transaction like SE16 and or SM30, if it's so the data are sorted by key fields and u can do nothing there, but u can use a different criteria for sorting in your custom transactions.

If you need to avoid the sorting in std trx u should use a counter (managed by a custom range number) as unique key field.

In this way u can sure the value of counter respects the order in which the records are inserted.

Max

Read only

Former Member
0 Likes
979

Hi Premraj

Try using CHAR instead of NUMC for defining temperature variables

Hope it helps

Regards

Vikas C

Read only

Former Member
0 Likes
979

Hi,

Remove the field from the key and see the difference.

Regards

Bikas