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

User, date Message
Written by isodee
8 years ago
Category: General
1 posts since Fri, 23 Feb 07
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?
Written by sit1way
8 years ago
3 posts since Sat, 02 Sep 06
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!
Written by ansgar
8 years ago
5023 posts since Fri, 07 Apr 06
See here: http://www.heidisql.com/forum/viewtopic.php?p=473#473

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