Hello,when I have an SQL editor panel open and I disconnect DB and connect to another db, I lose the execute icon related to that SQL Editor panel.I have to open up a new SQL Editor window to get the execute icon.I am on Windows XPToad 18.104.22.1684Best,Joe Bishop
Henrik,Is the situation described below standard behavior, or is this an issue thatneeds to be addressed?Dwight
This is not the behavior in 4.5 or earlier.It should be addressed. Closing a connection and reopening another effectively disables use of the open Edit windows. It forces you to open another window and copy your queries to the new window to get that execute icon enabled.
----- Original Message -----
Hi,I'm having the same problem. I notice that after using my editor tab for aspecific connection, I close that connection (production) and open another one(test) I get back to my editor tab then I try to execute the same query witheither F5 or F9 nothing happened. I Close Toad and reopened went to the sameexercise and nothing. It toke me some time to figure it out: I have to open anew editor for each connection.It would be great if this get fix for the next release.Thanks!
This was behavior was changed between 4.5 and 4.6. You can still reuse youreditor however you need to explicitly change the connection of an existingeditor window that has had a connection before to another connection. This isbecause we want to avoid people accidentally executing a script to a connectionthat they were not intending when all they did was close a connection and openeda new one to another database without closing the editor.To explicitly change the connection of the editor just click on the icon in thelower right corner of the screen and choose a new connection or right click onthe document tab and choose "Change Connection"./MauritzQuest Software
I had the same issue (after switching from Toad for MySQL 4.5 to 5.0) and was struggling to find out the root cause. I was more suspecting the windows OS, restarting the MySQL and connecting to the new DB on start up.My Suggestion: In this scenario, user should some how (ex: on pressing F9 or when new DB connection is opened) be prompted to re-attach the editor window to the new DB connection.
Us developers have discussed this at length and I'm afraid but this behavior will not change. One person accidentally dropping a table in a production database outweighs a lot people being slightly inconvenienced.It's still very easy to adopt a new connection to the editor either click on the icon in the lower right corner showing the connection for the current document or just right click on the tab of the document and choose change connection.