Error in the input field Sql in Execute query

database
activities
error

#1

I connect UIPATH to AZURE SQL database
I create a connection variable and add it to the Execute query. Next step I enter the Sql query end get error.

ystem.Activities.InvalidWorkflowException: The workflow has validation errors. Review and resolve them first. —> System.Activities.ValidationException: Compiler error(s) encountered processing expression “Select…”


#2

Hi Arseniy,

If you hover over the blue icon in Execute Query activity you will see the reason it’s not validating. Seems like your query must be surrounded by quotations. Or you can define a String variable containing your query and set is as input.


#3

Thanks for the idea with the variable, and now there is no error, but the requested data is not displayed.


#4

Please check this one: How to get value of Out Parameter of execute Query

It’s hard to figure out what’s going wrong with so little details.