When I use ExecuteNoQuery Activity, get “Run command: Must declare the scalar variable “@AssetNo”.” this error. but actually I already set the variable in Parameters. [1] [Parameter]

yes, not use by adding parameters, but adding the variable directly. [image]

ExecuteNonQuery error "Run command: Must declare the scalar variable "@AssetNo"."

Rahul_Unnikrishnan (Rahul Unnikrishnan) December 13, 2022, 10:33am 3

Please check the below Similar post.

Thanks

1 Like

Topic		Replies	Views
How to pass query from asset to execute query activity Help activities	12	1483	July 4, 2019
Passing variable to insert command sql query Studio studio	3	1537	July 18, 2020
How To Pass Dynamic Data To SQL Query From UiPath? Knowledge Base studio	6	8137	December 21, 2022
Execute query Help	7	3376	September 13, 2021
Using Variables in a SQL Query - String Commands must end in Double Quotes Studio datatable , studio , question , sql , activities_panel , variables_management , sql-stored-procedure , fetch-sql-data	11	2784	April 14, 2022