Toad switching connections and windows for certain action

Hi

13.3.0.181

I have 3 problems. I will upload picture for each one.

1. switching_between_connections_changes_active_page

2. closing_schma_browser_switches_connection

3. minimizeing_toad_changes_active_page

Regards
Raul

I believe that #1 is already fixed in the current beta. Please download it and give it a try.

#2 seems like it could be caused by the "Current connection only" option (options -> Toolbars/menus -> window bar -> current connection only). If the Schema Browser was the last window open for a connection.

I can reproduce #3 in the beta. I'll investigate and get back to you.

#2 may have to do with the order that the windows were opened.

Yes, I am using setting (show buttons for current connection):

image

#2 For this, seems like the "current connection only" is not a problem here. I just tried, without that tick, the issue still persists.

Order of windows opened also, does not seem to be case here. Same happens for me if I have "Session Browser" opened first and "Schema Browser" opened up second.

But it is mandatory, that you have "Schema Browser" active and then close it.
(if you have active windows "Session Browser", then it will not happen.

By the way: If you have just one window open "Schema Browser", and then closing it, the same thing happens - connection is switched.

Raul

I just tried this with Toad 13.3:

  1. Start Toad
  2. Make connection 1
  3. open Editor and Schema Browser
  4. Make connection 2
  5. Open Schema Browser and Create Table
  6. Click on the window bar button for Schema Browser 1.
  7. Close Schema Browser 1

Focus moves to the Editor for Connection 1.

Please modify the steps so that focus goes to Connection 2 on the last step.

These 2 steps need to be done in connection 2.

  1. Click on the window bar button for Schema Browser 1.
  2. Close Schema Browser 1

So correct way:
...
6. Click on the window bar button for Schema Browser 2 (connection 2).
7. Close Schema Browser 2 (connection 2)

Now the connection is changed to 1.

Raul

I just tried these steps with Toad 13.3

  • Start Toad
  • Make connection 1
  • open Editor and Schema Browser
  • Make connection 2
  • Open Schema Browser and Create Table
  • Click on the window bar button for Schema Browser (connection 2).
  • Close Schema Browser (connection 2)

when I did that, focus went to the Create Table window in connection 2.

If you zip up and send me your user files folder, I'll try again. You can send it to john.dorlon@quest.com.

What do you mean by that "Create Table window"

Do you mean Editor?

If yes, then do the same thing again, and additionally then close the Editor also in connection 2. Then the switch should happen.

Or just make connection 2, open editor in connection 2 and then schema browser in connection 2. And then close schema browser on connection 2. You should see connection switch then.

(for me, Editor is auto open always, when creating new connection view -> options -> window)

Raul

What do you mean by that "Create Table window"
I meant I opened the window: Database -> Create -> Table.
I'll retry with Editor instead shortly.

OK, so now the steps are:

  • Start Toad
  • Configure Toad to auto-open editor when a connection is made.
  • Make connection 1
  • Editor Auto-opens. Manually open Schema Browser.
  • Make connection 2
  • Editor Auto-opens. Manually open Schema Browser.
  • Close Schema Browser (connection 2)

I tried those steps with the current beta and with Toad 13.3. In both versions, Toad changes focus to the Editor for connection 2.

Please try these steps exactly and see if the problem still happens for you. If not, let me know what I need to do differently. Thanks.

-John

Starting from step 6 (including):

  1. Editor Auto-opens on connection 2 (so that Editor is only window on that connection)
  2. Just close Editor window on connection 2

After this your current connection should be switched back to connection 1

OR

  1. Editor Auto-opens on connection 2
  2. Open Schema Browser and Session Browser (in that order) in connection 2
  3. Left click on Editor and then right click and close Editor on connection 2 (after which you should still be in connection 2)
  4. Now Schema Browser should be active window and Session Browser the second one
  5. Close Schema Browser in connection 2

After this your current connection should be switched back to connection 1

These both cases could refer to the same issue.

Raul

It looks like basically you are:

  1. opening multiple connections with 1 or more windows in each.
  2. closing all windows of the active connection.

When this happens, Toad must activate one of the remaining open windows. At that point, the active connection must also change to the connection of the newly activated window. Otherwise you'd get into a state where active window's connection <> active connection. That is a weird situation that we try to avoid.

If you want to open a new window in the connection which you just closed all windows for, click the connection bar button first to re-activate that connection.