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]

[image] li.yu: Parameters Hi @li.yu Try constructing the string using the variable directly and pass the string to run command cheers

Hello @li.yu Please check the below Similar post. [image] How To Pass Dynamic Data To SQL Query From UiPath? Knowledge Base Hello Glen, Thank you for reaching out. Please use the below link to refer the images. https://uipath-survey.secure.force.com/CaseView/articles/…

thanks, I tried both ways, but failed.

thanks, I tried, but doesn’t work.

I have the same error. You know how to fix it?

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

Help Studio

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

Hello @li.yu

Please check the below Similar post.

Thanks

Topic		Replies	Views
Execute query Help	7	3696	September 13, 2021
Execute query with parameters is not working as expected Help	7	3970	March 7, 2022
Insert SQL with variable / parameter giving error in ExecuteNonQuery activity Help datatable , activities	14	8117	April 28, 2019
Passing variable to insert command sql query Studio studio	3	1713	July 18, 2020
How to pass a variable in an SQL query Help database , activities , question	12	35099	May 10, 2022

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

Related topics