SQL Assistant v.15.00 Keyboard Shortcut problems - Comment

Tools & Utilities
Enthusiast

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

2 REPLIES
Teradata Employee

Re: SQL Assistant v.15.00 Keyboard Shortcut problems - Comment

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.)

Enthusiast

Re: SQL Assistant v.15.00 Keyboard Shortcut problems - Comment

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