Can't get rid of 'order by' terms when browsing table data?

isodee posted 11 years ago in General
While browsing table data (with no own SQL clause ran, by HeidiSQL's Data tab) I can click on column headers to change the order of the data shown. And nicely enough, HeidiSQL allows also clicking multiple columns to make the ordering of data extremely easy in most cases.

But now, the problem is that you can't get rid of those order clauses nor you can edit their order. I'd assume that by RMBing over the columns, I'd have something like "Edit the order by string" or "Drop order by", but I haven't found anything like that. Basically only way to get rid of the, quite persistantly stored, 'order' you've created is to close HeidiSQL completely and run it again?
sit1way posted 11 years ago
Same problem here.

When viewing data (mind you, not via SQL editor) HeidiSQL appears to store previously clicked column(s)

So, for example, let's say I have a table with 3 columns (userID, first_name, & last_name).

If I click on userID column, HeidiSQL wil correctly sort by userID; however, if I tehn want to sort by last_name, HeidiSQL "remembers" the original userID sort request.

Looking at the SQL log, you'll see something like select * from myTable Order By userID asc, last_name, desc.

Thus userID sort always takes precedence, which makes a great product way less useful than it could be.

Please fix, HeidiSQL Developer!
ansgar posted 11 years ago
See here: http://www.heidisql.com/forum/viewtopic.php?p=473#473

Please login to leave a reply, or register at first.