Toad World® Forums

Check SQL (VS) Execute SQL - New Feature Request for next development cycle or Current Beta !


#1

This is not a broken code issue this is a NFR… ( I am sure that we will have
several differences of opinion here)

When I run a Verify SQL or Syntax check the result looks just like a EXECUTE
(F5) run (See table below) …

The only clue is the drop statement.

Is there are way, you can adjust the Verify SQL command to add additional
Message box such as what you have for a failed Verify run, to be displayed.

The new message box would Say à NNN lines processed and SQL Verify
successful !

Currently, the Verify syntax goes directly to the message tab, which then
displays the results there, which is not broken.

I almost had heart failure (I do that a lot) when I verified my SP syntax and
got the message the looked like a had dropped and re-created the procedure.

I get around this by using the following syntax, which why you have the message
‘procedure PROC_ISTA_PCI_ NONPROD_CLEANSE - dropped’

IF EXISTS ( SELECT * FROM sys.objects WHERE object_id = OBJECT_ID (N
'[dbo].[PROC_ ISTA_PCI_ NONPROD_CLEANSE] ’ ) AND type in (N ‘P’ , N ‘PC’ ))

BEGIN

DROP PROCEDURE [dbo].[PROC_ ISTA_PCI_ NONPROD_CLEANSE] ;

Print ( ‘procedure PROC_ISTA_PCI_ NONPROD_CLEANSE - dropped’ )

end

else

Print ( ‘procedure PROC_ISTA_PCI_ NONPROD_CLEANSE - Not Found’ )

So please look this idea over and let me know what you think .

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn. com

678.414.0090 my cell Primary

image004.png

image001.gif

image004.jpeg

image001.jpeg

image007.jpeg

image008.png
image001.png


#2

Thank you for you input.
This is a good suggestion. I’ve created enhancement ST#76081