topic Re: Solution for avoiding sort in Application Development and Automation Discussions

Solution for avoiding sort

Former Member — Tue, 17 Feb 2009 09:47:35 GMT

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,

Re: Solution for avoiding sort

Former Member — Tue, 17 Feb 2009 09:51:17 GMT

But where have u the default sorting?

Max

Re: Solution for avoiding sort

Former Member — Tue, 17 Feb 2009 09:52:21 GMT

Hi Premraj

Try using CHAR instead of NUMC for defining temperature variables

Hope it helps

Regards

Vikas C

Re: Solution for avoiding sort

Former Member — Tue, 17 Feb 2009 09:54:22 GMT

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.

Re: Solution for avoiding sort

Former Member — Tue, 17 Feb 2009 10:13:03 GMT

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

Re: Solution for avoiding sort

Former Member — Tue, 17 Feb 2009 10:23:34 GMT

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

Re: Solution for avoiding sort

Former Member — Tue, 17 Feb 2009 10:54:02 GMT

Hi,

Remove the field from the key and see the difference.

Regards

Bikas