Last active Editor moved to a new connection (4270763)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Last active Editor moved to a new connection
Description

Selecting a command in 'Recall previous SQL statement in the Editor' (F8) switches the connection of Editor. Is this by design?
Steps to reproduce:
1. Open a connected editor by going to Session | New Connection. called Conn1
2. Type a command of your choice
3. Configure Toad not to open any editor or schema browser on starting a new connection by going to View Menu and selecting Toad Options.
Under the Editor behaviour, uncheck Auto Open. Apply | OK
4. Now create a new connection (Conn2) to connect with a another schema from Session | New connection
5. While the new connection is highlighted or active, hit F8 and double click on the syntax that you entered in step 2

Notice that the connection for your editor changes from the old connection (Conn1) to the new connection (Conn2)

Expected Results:
Should the connection not have remained with conn1?
Resolution

This is by design. SQL Recall is not database specific.
It will keep the history of what database you last executed a query on, but that query can be run on any database depending on what connection you are currently on.
If you want to run it on another connection, you have to change the editor session to the other database.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title