Hi,
I need a shortcut that will open an editor when I am in the Schema Browser, and that editor should be connected to the same user and database connection as the Schema Browser.
And also a shortcut to open the Schema Browser using the same user and database connection that I am currently using in the editor.
When you open any window, it always opens in the same connection.
You can already use the built-in menu shortcuts:
Alt+D, E for Editor
Alt+D, B for Schema Browser
If you don't like those you can go to Options -> Toolbars/Menus -> Shortcuts and define your own. Note, I typed "database" into the filter at the top to shorten the list
Which shortcut allows navigation to the next editor or the previous editor when multiple editor windows are open?
I don't think there is one to go from one editor to the next, specifically.
You can use CTRL+TAB to go forward to the next window or CTRL+Shift+Tab to go back.
That, paired with the "Current connection only" option (right-click on window bar button) will get you pretty close.
This is still not a complete solution, because you may want to switch from one editor to another across two different connections and when you have many windows open, Ctrl+Shift+Tab won’t be so helpful .
In addition, regarding the Current Connection Only option: once you enable it and you have only an Editor open in the Window Bar, when you switch from the Editor to the Schema Browser, the Schema Browser becomes an additional window that should appear in the Window Bar under Current Connection Only. However, that is not what happens. Even though the Schema Browser is added, it is not displayed in the Window Bar. Is this a bug or a feature?
In addition, regarding the Current Connection Only option: once you enable it and you have only an Editor open in the Window Bar, when you switch from the Editor to the Schema Browser, the Schema Browser becomes an additional window that should appear in the Window Bar under Current Connection Only . However, that is not what happens. Even though the Schema Browser is added, it is not displayed in the Window Bar. Is this a bug or a feature?
I can't reproduce this. Can you make a short video (or a series of screen shots) so I can see your steps?
This is still not a complete solution, because you may want to switch from one editor to another across two different connections and when you have many windows open, Ctrl+Shift+Tab won’t be so helpful .
Right. I said "It gets you pretty close". There is no shortcut to do what you are asking for. I guess you'll have to use the mouse here if you don't like my suggestion.
Edit: I guess you could do Alt+W, then select whichever editor you want from that menu, but this is probably slower than using the mouse.
It is very simple to reproduce:
open connection C1 in SB
Open connection C2 in editor
Right click on that editor (connection C2) window bar button and choose "Current connection only" option .
Now the window bar button have only connection C2 window buttons.
click on SB icon or navigate to SB, now SB switched from connection C1 to C2
It should be expected that the SB window bar button will show up now in the window bar, but it is not there.
It works fine for me. Thank you
Hi Mordechai,
I followed your steps. This is how my Toad looks after step 4. C1 is the blue one. C2 is red.
Where did you click exactly for Step 5? If you clicked as shown below, that will just open a new schema browser in C2 as expected. It sounds like this is what you did but I am not sure.
If you wanted instead to go to the already-open but hidden schema browser for C1, then click the connection button for C1 and then it will appear (and the C2 window will be hidden).
Another way you could have returned to the C1 Schema Browser is by clicking here:
I am wondering whether you have the Connection bar hidden. When you enable Current Connection Only, you navigate between connections with the Connection bar buttons. If Connection bar is hidden, then you only see Window buttons, and with Current Connection Only enabled, you won’t see the buttons for other connections. You have to have the Connection bar in view to navigate connections.
Cheers,
Russ
