distal-attribute
distal-attribute
distal-attribute
distal-attribute

Double clicking on database name in treeview puts the name into the editor

Battlestar posted 2 years ago in General
Hi!

Everytime I just want to expand the sub items of a database item using a double click HeidiSQL messes with my SQL script because it adds the database name into the script.

I understand this feature but it should only paste the name of the clicked item when it was already focussed. Otherwise it confuses the user who just double clicks a parent item to expand / collapse it.

Greetings

Benjamin
egodoyc posted 2 years ago
Hi !

I Agree with that.

Greetings,
Enrique
ansgar posted 2 years ago
Try the following:
* rightclick the tree
* click "Tree style options"
* activate "Auto expand on click"

I believe that could help you as you don't need to doubleclick any more then.
Battlestar posted 1 year ago
That is quite a solution but this is not intuitive because the user does not expect this behaviour. Why should I get used to single clicking a tree node when I need to use a double click in other applications?
apric posted 1 year ago
I had this issue multiple times as well.
In some random place in my (large and complicated) queries a syntax error occurs because i tried expanding some DB in the tree view (working with several hundred databases!).

Add this to the shitty MySQL error messages and you wasted several minutes of your life...
Very annoying :(
apric posted 11 months ago

Try the following:
* rightclick the tree
* click "Tree style options"
* activate "Auto expand on click"

I believe that could help you as you don't need to doubleclick any more then.



This workaround does not help either, since this only helps for opening a DB.
When trying to fold it again, you have to double click, and the DB name gets put in any open query window like before.

Is there an official HeidiSQL bug tracker somewhere?
This problem should easily be fixable by commenting out the code line causing this.
ansgar posted 11 months ago
Well, one can already drag and drop any tree node to the query editor, so I guess I can safely remove the doubleclick-code, without harming any user.
apric posted 11 months ago

Well, one can already drag and drop any tree node to the query editor, so I guess I can safely remove the doubleclick-code, without harming any user.



Or make it an option in the settings.
Or make this functionality use an additional key like CTRL+click / CTRL+doubleclick.
ansgar posted 11 months ago
Just removed that double-click code, in r4999. Huuh, next commit will be r5000...
apric posted 11 months ago

Just removed that double-click code, in r4999. Huuh, next commit will be r5000...



Great news, thanks ansgar!
No more broken queries by accident!

Will donate a little something tonight, listening to customer feedback shall be rewarded.
russlo posted 11 months ago
Meh. Some of us actually liked the double click feature - any way we can get that as a toggle-able option in the preferences somewhere, please? It was so noticeable after the update that I came looking on the forums and found this thread. Thanks.
apric posted 11 months ago

Meh. Some of us actually liked the double click feature - any way we can get that as a toggle-able option in the preferences somewhere, please? It was so noticeable after the update that I came looking on the forums and found this thread. Thanks.



In the meantime then you can use drag&drop: item to query window.
russlo posted 11 months ago
I tried it that way for about a day and then reverted back to build revision 9.3.0.4998 - thanks anyways.
wer posted 11 months ago
Thanks, this was really annoying.
heidiuser123 posted 11 months ago

Meh. Some of us actually liked the double click feature - any way we can get that as a toggle-able option in the preferences somewhere, please? It was so noticeable after the update that I came looking on the forums and found this thread. Thanks.



In the meantime then you can use drag&drop: item to query window.



I also was alarmed that the feature was missing and came to the forum for the exact same reason.

If you could make it toggle-able, that would be great.
ansgar posted 11 months ago
Why not use drag'n drop from the tree into the editor? This doubleclick action always looked dodgy to me, not intuitive in some way.
russlo posted 11 months ago
I use macros to generate most of a simple SQL statement for me, and then drop my cursor into the appropriate spot. I double click a table name, it fills in in that spot. I type a space, then a character for an alias. I press the down arrow. I double click another table name. I type in an alias character, space, the keyword ON, space, maybe I double click on my Column reference on the right side to avoid having to type in all of the ON statement, press the down arrow and I'm in my WHERE clause. You can see how that flow would be slightly disrupted by having to drag the table to the correct location. It's definitely a small gripe, but it was a feature I came to rely on and my workflow is at least slightly faster with it.

In an AutoHotkey script that runs automatically when I start up my computer:
::SELJOIN::SELECT * {ENTER}FROM {ENTER}JOIN {ENTER}WHERE 1;{UP}{UP}
jonathan posted 11 months ago

[quote=russlo]Meh. Some of us actually liked the double click feature - any way we can get that as a toggle-able option in the preferences somewhere, please? It was so noticeable after the update that I came looking on the forums and found this thread. Thanks.



In the meantime then you can use drag&drop: item to query window.



I also was alarmed that the feature was missing and came to the forum for the exact same reason.

If you could make it toggle-able, that would be great.[/quote]

Same here. I was looking through the recent builds to find out if it was some kind of bug, found this issue. I use double-click on tablename a lot (at daily base) so it is a real miss. Drag&Drop costs so much more time...
ansgar posted 11 months ago
Well I guess I'll make this double-click feature customizable. Although I'm against blowing up the preferences dialog with such minor stuff. But the users here decided it.
russlo posted 11 months ago
Thank you.
ansgar posted 11 months ago
Done in r5007.

See the new check option when right clicking the tree, then click "Tree style options", then click "Double click inserts node text". Activated by default, for the benefit of all the users having loved this feature.
apric posted 11 months ago
Best solution for all users, thanks :)

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