Update Database activity Query

[Tapiwa (TapiwaMakamure)]

Hie guys. I am using execute query activity with my query as “UPDATE Details Set Status = ‘1’ Where Name = Extract”. Extract is a variable name. How can i pass Extract variable withought getting an error.

[Lahiru.Fernando]

Hi @Tapiwa

Try using the Execute Non Query activity. In there, you can specify your update query. For the “Extract”, add a variable as @VariableName just like you would do when writing sql scripts

Next, in the parameter option add a parameter using the same variable name along with the @ sign.

Refer to this post as well…

Create SQL query parameters dynamically

The sql Command property is String. Therefore you should be able to create your query and update it using variables e.g. strSQLCommand = "SELECT * FROM " + strTableName + " WHERE ID = " + strID + “” (you’ll have to work out how many end quotes!) In the above strTableName and strID are variables generated in your process from any source, which are then included within the SQL query string. You would then put strSQLCommand into the sql Command property instead of the text.

Hope it helps

[Tapiwa (TapiwaMakamure)]

Thanks buddy it helped. Solution
“UPDATE Details Set Status = ‘1’ Where Name = @Ex” and then added a parameter with name being Ex and value being EXTRACT

[Lahiru.Fernando]

If that helped, please mark my answer as the solution too… Running SQL scripts in UiPath is an area where people mostly get stuck. So having a marked solution for such scenarios would greatly help them…

Thank you. and glad that I was able to help…

Good luck and happy automating!!