Page 1 of 1
handling SQL result
Posted: Thu Mar 11, 2010 12:23 am
by Gekseppe
Hello;I need some help to write a task with the following purposes:- run SQL with RoboTask;- Store SQL output in a text file.Any help/suggestion will be appreciated !Many thanks.
handling SQL result
Posted: Thu Mar 11, 2010 10:57 pm
by Oleg
What SQL query did you mean?
If you want to use "SELECT" query you should use DataSet Loop.
You can process retrieved data as you wish within the loop:
- set variables
- output into text files
- run another actions
- etc.
handling SQL result
Posted: Thu Mar 11, 2010 11:01 pm
by Oleg
In addition:
SQL Query action is used if you want input or change the data (queries like UPDATE, DELETE, INSERT, EXECUTE PROCEDURE, etc.)
Such queries can return only amount of rows affected.
handling SQL result
Posted: Mon Mar 15, 2010 1:22 am
by Gekseppe
Many thanks for your replies."What SQL query did you mean?
"I meant to use RoboTask to connect to a Access DB so to retrieve data and then store the SQL output in a text file.
handling SQL result
Posted: Mon Mar 15, 2010 4:47 am
by Oleg
I think that you want to use "SELECT" query.
Therefore you should use DataSet loop and compose some text file within the loop as you wish.