Toad World® Forums

Toad-SS 5.0.0.444 Result window possible CACHE problem


#1

When running a simple select statement followed by a similar select statement as
you see in the sql below,

I never get the Second SQL execution results to display … I have even tried a
Go between the two selects and that doesn’t work either.

I get the messages value but just not the result set.

Please note the following is blank

Hopefully, this is not a problem but an Option. However, I suspect there is
something else-a-going-on in the wild-wild-world of Toad-SS 5.0.0.444…

There4, I would like to know what to do to trap and report this problem so that
I and others who are experiencing it as well can give you what you need to fix
the problem. (No Support bundle supplies as of this email…

The work-a-round is to just run the second sql Select statement after the first
one finishes.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary

select * from JustEnergy.dbo.DirectDebitCreditCard

where upper(cardType) like ‘%DISC%’ – rowcount 4950

–go

select * from JustEnergy.dbo.DirectDebitCreditCard

where upper(cardType) like ‘%VISA%’ – rowcount 138765

image001.gif

image002.jpeg

image004.png