One-click toggle to turn query "on" or comment out

charlieo posted 3 years ago in Feature discussion
Often times I am writing a series of complex queries in one tab. As I'm working through issues, I often want to turn some of the queries "on" or "off". What I do now is /*...*/ which works but it's a pain when I'm juggling lots of things on and off.

It would be great if there was a simple, direct way to toggle a given query on or off. For example, place the cursor anywhere in the given query and then double click in the left gutter (line #s) and the query where the cursor is sitting (through the nextwinkis commented out. Reverse the process to turn it back on.

Would be very nice.

Charlie O.
ansgar posted 3 years ago
Rightclick > "Un/comment"

You can assign a shortcut to that menu item, in Tools > Preferences > Shortcuts > SQL
charlieo posted 3 years ago
Nice. Wow, I had no idea these were there!

Thank you.


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