Gridsort in SQL-Window

[TenGor]

Hy,

i recocnized the following:
i often sort the columns in Grid from SQL-Window after i execute the select.
Till now this sort still exists after an other execute (same statement).

in 6.0.4.906 it seems to me that the Grid sorts the columns every execution in the default-sorting (as the desc of the table).

Any suggestions?

 

[Marco Kalter]

This has always been the case. The sort order was never preserved when (re)executing a query. I can add it to the list of enhancement requests if you want though...

 

[TenGor]

>This has always been the case.

Really?
I thought this sort was preserved when (re)executing the query again.
Perhaps in version 5?

Well i could try it with an old Version of PL/SQL...

And it would be nice, if you could add it to the list of enhancement requests if it's really not preserved.

 

[Marco Kalter]

I did in fact try it with 5.1, just to be sure. I have added it to the list.

 

[TenGor]

Well i think there i a little misunderstanding.

Could it be that you mean the after-selection sorting for columns where i can sort asc and desc?
(little arrow on the right side of column)
This would be nice if remembered and perhaps possible for more than two columns?

But the thing i ment was to drag&drop one or more columns and move them on an other position within the grid. This works in 5 (and i think some 6 ago too), but not in 6.0.4.906.
There i have every time a unchanged grid with column sort as default from table.

 

[Marco Kalter]

There was indeed a little misunderstanding! We'll fix it.

 

[TenGor]

Thanks,

and think a little bit about:
After Sort colums for more than two columns?
Sometimes it would be helpful to sort f.e. 3 or 4 columns. Ok it can be done with an "order by" but sometimes one is lazy (f.e. me)

 

[Marco Kalter]

I have added this to the list of enhancement requests.