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
I have defined One/Connection for Schema Browser therefore, it should not open a new window, but instead switch to the existing one.
It is not hidden.
No.
I said: If you clicked as shown below, that will just open a new schema browser in C2 as expected.
Here, your active connection is C2. If you click the Schema Browser icon (indicated by the red arrow)....
In the case of my steps above, C2 did NOT already have a Schema Browser open.
Sorry, I mistakenly wrote that I have defined One/Connection for Schema Browser.
The correct statement is that I have defined One/TOAD for Schema Browser.
Ok I can reproduce that the Schema Browser changes connections when you have the "one connection/toad" option set and you click the button to open a new SB when there is already one open.
For what it's worth - any window that you set to One/Toad will do that.
It's probably been that way forever, but it does seem like a bug. I'll fix it.
I was just looking at changing this.
Assuming you have Schema Browser (or any window) set to One/Toad, and you follow these steps:
At this point, when we make the already-open, connection 1 schema browser active, one of two things needs to happen:
Either the Schema Browser needs to be changed to the active connection (which seems buggy)
Or the active connection needs to be changed back to connection 1 (which may also feel buggy because in step 4 you just changed it by clicking connection 2's button).
We definitely cannot make the schema browser (which is set to connection 1) active and leave connection 2 as the active connection. That's just asking for trouble.
I am going to make the change, but I just wanted to point this out.
This is exactly the current behaviour and it is OK for me.
I don’t understand why: “it is just asking for trouble”?
After all, whenever you switch from one window to another—for example, from the Editor to the Schema Browser or vice versa—the target window takes on the connection of the source window.
No, that is not the current behavior. The current behavior is:
The thing that would be asking for trouble would be if somehow the Schema Browser (set to connection 1) were active while the connection bar showed connection 2 is active. That's asking for trouble because in this case there are 2 ways to define the "active" connection and they do not agree with each other on which connection is actually active. So it would be easy to do something on the "wrong" connection.
You said:
After all, whenever you switch from one window to another—for example, from the Editor to the Schema Browser or vice versa—the target window takes on the connection of the source window.
Yes, but this is an action on your part to switch from one connection to the other, and when you do that, the connection bar always agrees with the connection of the active window. We never want them to disagree.
