Toad World® Forums

Messages for multiple update statements


#1

I’m new to TOAD; I’ve used SQL Management Studio before. In Management Studio, if I run multiple update statements, I get a message for each update saying how many rows were affected. In Toad, the message has one message saying how many records were updated in total. Is there a way to get Toad to list the number of records updated for each update statement? I need to know that each update statement worked. If one of them affected 0 rows, I need to know that, not have that information get lost in a total. Thanks.


#2

Try !

Turn on Message / Text Output after your run and see what you get…

I am always toggling this feature to see the messages.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary
image002.jpeg


#3

Try !

Turn on Message / Text Output after your run and see what you get…

I am always toggling this feature to see the messages.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary
image001.gif


#4

Try !

Turn on Message / Text Output after your run and see what you get…

I am always toggling this feature to see the messages.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary
image001.png


#5

It doesn’t help. I have the exact same problem - and while turning on text messages makes the message easier to read, it does not change the message.

However - if you put “GO” between the statements, Toad will generate a new message (+ count) for each statement, thereby yielding the record count for each.

No count is however given for SELECT-queries.

It would be a much welcomed improvement if Toad were able to show records affected messages in the same way as SSMS.

Regards /Jens


#6

That did it! Thanks.