Toad World® Forums

Running a script to update data

Does anyone know if I can automate the running of a script in Data Point that will update data and then commit the change to the database?

Message was edited by: linda.rogers_765

Sure, you can run any script using the Execute Script activity.

Debbie

I tried to run a update statement on the local database as part of an automation script and it does not work. I ran the same script outside of the automation script and it worked fine. I set a variable = to a distinct date field and the tried to UPDATE table, SET col1 = variable, and it returned all blanks. Is it possible that the variable doesn’t match the data type of the date field? I did use the same variable in another query as a date parameter and it worked fine.

Can you publish a log and Automation script itself for us to take a look?

Thanks,

Igor.