Toad World® Forums

Data automation - problems using an "update" SQL script

Hi. I have a SQL script that performs an update, and I want the automation script to wait until that update is complete before moving on to the next step. I’d also like to be able to have the # of rows updated put into a variable that I can then use. However, I haven’t been able to figure out how to do either one: when I put an update or insert script into a automation flow, it doesn’t even run the update/insert and just blazes on to the next step. No error - nothing. Any ideas?

UPDATE - turns out that the update IS working (I just couldn’t see it running in the lower status bar like when I run the script manually … not sure why) but I still would like to know how to have the automation script wait until the update is complete before moving on to the next step.

Message was edited by: biz_questsoftware_234