How to execute multi line SQL queries (complex sql queries) in using "EXECUTE QUERY" of UI PATH

Help
1

Hi,

How do I execute a multi line query just like below? I tried using the query below but as a result no query results are being displayed. I tried executing the query on the Mysql and DB beaver and as a result, I was able to see a populated query result. Please help me.

image
image736Ă—417 8.48 KB

Thank you!

1 Like
2

But this is a UiPath forum…

3

I know that this is a UI Path forum and im using this query in my “execute query” function of UI PATH therefore my question is VALID :slight_smile: .

4

Correct me if im wrong… I think this is a bug / a limitation of UI PATH? Im expected to get 4 results query and as a result of using “execute query” it only returns 1 query.

I think UI Path cant handle multiple line sql or sql statements with multiple query results.
:scream:

1 Like