Database query execution issue

Help Studio
1

Hi All,

I am facing issues while running the multi line SQL statement using Run Command activity.
But same statements are getting executed if i run them individually.
I am reading the query from text file and each statments are ended with ;.

Example:
Drop Table temp_0;
Drop Table temp_1;

Kindly help if anyone knows how to resolve it.

2

@darshanbm455

Multiple queries are not aupported…because if you see in run you will have an output as well…you cannot do with one single activity

Wither use multiple or create a stored proc and invoke it from UiPath

Cheers

3

Anil,
But query is not returning anything.

4

@darshanbm455

Its not about returning but how the activity is

Cheers

5

Drop Table queries don’t return anything.