Can run multiple lines of query in uipath 'excute query activity'?

Help Activities
, ,
1

Is there no choice but to add multiple 'excute query capacities?

2

Hi @S_Sim
The expectation from Execute Query is that it will return a result, which can be tricky to manage if one instance of the activity allowed multiple queries.

There are a couple of options to handle this.

  1. You may either add multiple activities with one query each, or
  2. Write a stored proc or function to do complex stuff on the database side and call the SP or function from UiPath.
1 Like
3

thank you ash

1 Like
4

Hi @S_Sim,

If you decide to use the 2nd method suggested by @RPAForEveryone, then you can refer to solutions in this thread SQL Stored procedure Passing Parameters To fetch particular records to execute your Stored-Procedure via UiPath and get the DataTable from th Database.

3 Likes
5

Thanks so much

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.