Without going into too much detail as to why I have to do this, I want to explain what I want to do.
I want to create a table where each row is a sql command I want to run. These could be queries, possibly with parameters, could be inserts, deletes.
I would like to be able to loop thru these records and execute the sql statements one at a time. I would also like log in another table the rownumber, maybe even the actual sql statement and how long the statement took to run. I don't think I care about how many records were updated/inserted.
I also want the total queries to be able to run as long as they need to without any timeouts. I will be accessing a mysql database if that's needed.
I am fairly new to RoboTask, so if someone could help me get started that would be great.
Thanks
Alan
loop thru text file or database records and execute sql
Re: loop thru text file or database records and execute sql
First create a table in the database and put there all SQL expressions you want. One SQL per row.I am fairly new to RoboTask, so if someone could help me get started that would be great.
You can process them by using Dataset loop
Another way:
create text files with SQL expressions. One SQL pre file.
You can process them by using File Loop
Oleg Yershov