Toad World® Forums

Query Builder doesn't save the sort order in .tsm file?


#1

It seems that when saving a Query Builder file (.tsm), it doesn’t always maintain the sort order on re-open? Can anyone please clarify/explain? Thanks.


#2

If you sorted a column by clicking on a column header, this is not saved in the file. You need to click the sort Asc/desc and make it part of your Query.

Debbie


#3

It seems to initially save the sort order, but if you modify the query (even in a way unrelated to the sort, such as a Where Condition), the tool states “The query has been modified. Do you want to update the edited query from the diagram?”. Upon clicking ‘Yes’, the previous sort order is lost, and an unexplainable sort order is applied. Is this normal behavior?