All Forums Tools
20 Aug 2014
SQL Assistant v.15.00 Keyboard Shortcut problems - Comment

I just installed the new TTU 15.00 SQL Assistant, but I having problems with the keyboard shortcuts. In previous versions the (CTRL + D) turned text to and from comments. If no text selected then the line with the curser was transformed to/from single line comment with “--“, if block of text was selected then it was transformed to/from comment block with “/*   */”.
In SQL Assistant 15.00 then (CTRL + D) is not defined at all.
I found in the Customize Keyboard menu, Category: Query, then Comment: Comment, I have manually assigned this to (CTRL + D). Now I am able to change a Comment block on/off. But when no text is selected then the single line comment version are not working.
How do I make the (CTRL + D) to handle both single line comment and block comment, like in the previous versions of SQL Assistant?
Peter Schwennesen

MikeDempsey 94 posts Joined 10/06
31 Oct 2014

In 15.0 Ctrl+D is used to remove Bookmarks while Ctrl+/ is used to toggle comments.
The latest efix also allows you to use Toggle Comment to comment the current line when no text is selected.
(It does however use /* ... */ comments rather than -- comments.)

bhushan.koli 7 posts Joined 08/16
18 Aug 2016

These are few keyboard shortcuts (Used in only GUI mode On windows/linux) 
F2 : It will open QUERY BUILDER, with SYNTAX for all SQL Queries.
F5 : Execute SQL Query
F6 : Explain Plan for SQL Query
F9 : Execute SQL Queries in Parallel
F10 : Abort SQL Query
F11 : Display Last Error encountered.
Ctrl + N : New SQL Query Window
Ctrl + Q : FORMAT SQL Query
Ctrl + U : Convert to UPPERCASE
Ctrl + H : Find & Replace

You must sign in to leave a comment.