Toad World® Forums

Multiple select statements not all executing

This just started happening yesterday afternoon.

I have many sql files with multiple select statements. Yesterday afternoon, Toad started only executing the first one and stopped. I can insert goto's to get to others or hilite and run them, but Toad will not execute all of them. I have been using Toad for 7 years and it ALWAYS has worked properly and executed all of the selects in a SQL file. Toad support tried to help last night and thru a combination of removing all result sets, hitting F5/F9 combinations, I can get it working sporadically.

But, I need it working properly with no work arounds.

Any ideas?

Hi, if you've already started working with support it will get to us eventually. Thanks