handling SQL result
handling SQL result
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
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.
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
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.
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
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.
"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
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.
Therefore you should use DataSet loop and compose some text file within the loop as you wish.