Run Query Only Selected Text
IMHO, it looks pretty interesting. I know nothing about HeidiSQL guts (I'm not a developer) but perhaps it could be implemented by keeping current commands internally:
- Run all
- Run selection
- Run current query
... and exposing them this way:
- Run -> chooses automatically between "Run all" or "Run selection"
- Run current -> chooses automatically between "Run current query" or "Run selection"
It's a subtle but potentially confusing change so further feedback and analysis would be required.
(If I still don't understand your request, please feel free to add more clarifications but I love the feature I've described nonetheless).
Hi,
Firstly thanks for great software!
Has this been implemented as yet?
I feel it's really essential to have the same shortcut to run highlighted and non-highlighted queries. It's must more intuitive and really speeds up the development process.
Would be happy to donate for this feature as I run into it all day and it really impacts my workflow.
Thanks again! :)
I would like to second this feature.
Coming from SSMS, it automatically detects if there is selected SQL and runs JUST the selected portion. If nothing else, put a checkbox to allow the user to decide if it should auto-execute the selected text or force the user to press CTRL-F9.
I would also like to see if we can map the "Execute" key. SSMS uses F5 to refresh, and I find myself hitting F9 when I switch back and forth.
Coming from SSMS, it automatically detects if there is selected SQL and runs JUST the selected portion. If nothing else, put a checkbox to allow the user to decide if it should auto-execute the selected text or force the user to press CTRL-F9.
Sorry, I see there are quite some users asking for this. Only I'm still thinking that having different shortcuts for different actions is more clear and more easy to understand in terms of usability. Having the same shortcut doing two different things dependingly on a text selection sounds non-intuitive.
I would also like to see if we can map the "Execute" key. SSMS uses F5 to refresh, and I find myself hitting F9 when I switch back and forth.
You can customize your keyboard shortcuts in HeidiSQL: Tools > Preferences > Shortcuts .
Having the same shortcut doing two different things dependingly on a text selection sounds non-intuitive.
I disagree... it is un-intuitive that the selected portion does NOT run because that is how almost all other query tools work. You could certainly create a checkbox that is un-checked by default, but allow those of us that want this functionality to check it.
You can customize your keyboard shortcuts in HeidiSQL: Tools > Preferences > Shortcuts .
Awesome! Thanks!
Please login to leave a reply, or register at first.