Add to Saved options missing from Recent window

Toad for Oracle
1

Selecting Add to Saved SQLs from the main Editor menu presents all the options.
image

The Add to Saved option from the Recent window only allows selection of the Category but not Name, Schema and Database.
image

It would be convenient to also have the Add to Saved function available in the context menu of the editor window.

2

We've actually got some improvements to SQL Recall ready for version 17.0.

One of them is: Add To Saved from SQL Recall Recent tab will include Name. (Would Schema/DB helpful? That should just come over from Recent)

The Editor Context menu is a mile long already. :frowning: You could make a shortcut for it under Options -> Toolbars.

3

Acknowledged, and Quest Dev please take note... two requests here...

  1. Allow Toad users to specify AT THE VERY LEAST the name of the desired Saved SQL when rt-click-> Add to Saved from the SQL Recall Recent list. The Schema and Database do get carried over when the new Saved SQL entry is made currently, but would be nice for the user to specify even those fields, if desired. Otherwise, the SQL entries get named "Statement", "Statement(1)", "Statement(2)", etc.

  2. Agree it would be useful to have an Add to Saved SQL choice when rt-clicking a portion of script in the Editor.
    Work-around:
    Alt-ts
    is the menu shortcut key to bring up the Add to Saved SQL pane. So, highlight in the Editor the portion of code you want to name, hit Alt-ts, and you get the save SQL pane.
    Also, a user-defined shortcut of your choice can be added for the "Add to Saved SQL" Editor function via the Shortcuts list in the Toad Options base.

Hope that helps for now.

1 Like
4

Agreed, the context menu is already too long. Is there a way to customize it and remove items I rarely use? I'm probably getting off topic now.

One of them is: Add To Saved from SQL Recall Recent tab will include Name. (Would Schema/DB helpful? That should just come over from Recent)

Yes, schema/DB would be helpful

5

It's not possible now but that's a good idea. We allow toolbars to be customized, why not context menu?

1 Like
6

Is there a reason why Recent doesn't save the terminating semi-colon with the SQL?

More often than not I'm working in an editor that has other SQL so having the terminating semi-colon when I scroll through with ALT-up/ALT-down would allow me to hit F9 right away to rerun it without having to add a semi-colon at the end.

7

no, but we can add that

1 Like