Toad World® Forums

SQL Execution dependent on established connection


#1

I noticed in QSO 7 Beta that SQL executions in SQLab are now dependent upon having a correct database connection open, whereas with the previous version, you could simply change the parsing user by changing the name in “Set Schema”.

This is a change to the previous workflow. Is there any way a change to “Set Schema” could invoke a new database connection on the fly or even automatically open the Connection dialog ?


#2

The behavior to Set Schema in the Lab is not changed in this version 7. What it does is to change the current schema of your database session. It will not, and should not, change the connection to a different database. This is also the same in the previous version.

I hope this will clarify the use of the Set Schema dropdown. If there is something you want to do in the Lab but you cannot find it, please let me know and I will try to help or check if it is a missing function.

Thanks.