Every so often I forget I have a query running in a background tab in the Editor and go to switch connections. TOAD assumes I’m smarter than I am and actually does change the connection, but from that point on, the tab is unclosable to me. It thinks it is still running a query, so it asks if I want to cancel execution and close the tab, but even when I say yes, it can’t seem to be able to do that. No error messages, it just doesn’t show the query as run or close the tab.
I would love a nicer solution to this than having to use the Windows Task Manager to kill TOAD. Is there a way that either TOAD will prevent me from changing connections when a session using that connection is active or a way that after I’ve done the unthinkable that I can tell TOAD that the query that it thinks is running is actually lost so I can close the tab (and TOAD) gracefully?
Digital Strategies, Cru | Data Sciences & Analytics