I’m trying to move from RapidSQL to Toad 3.2 and struggling with a couple of things.
1 - How do I show the results of a script that has multiple sets of results. I just want to scan down each set of results quickly. Rapid sends it all to one results pane and does its best to creating suitable colunm widths. It seems I can only show one result set at a time in the Toad Results pane and this is a real drag having to move to each result set separately.
2 - The Execute icons are grayed out in version 188.8.131.526 when I open files that don’t have a .sql suffix. I have hundreds of files with varying suffices that have SQL in them that I want to be able to execute. If I open the same files in Toad 184.108.40.2064 the execute icon is not grayed out. I’ve found a way round this by opening a SQL Editor and then pasting the code into it but this isn’t practical given the number of files I have to work with on a dily basis. I can’t find a setting anywhere that allows me to associate file suffixes with the SQL editor
- I have scripts that create #temporary tables. In Rapid these #tables are removed automatically when the script completes. In Toad, if I run the script again it complains because the #tables are still there. I don’t really want to chang all my scripts just to drop #tables - is there a way to tell Toad to drop them after each execution as in Rapid?