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

[li.yu (Penny)]

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.

[Anil_G]

@li.yu

Parameters

Hi @li.yu

Try constructing the string using the variable directly and pass the string to run command

cheers

[Rahul_Unnikrishnan]

Hello @li.yu

Please check the below Similar post.

How To Pass Dynamic Data To SQL Query From UiPath

Hello Glen, Thank you for reaching out. Please use the below link to refer the images. https://uipath-survey.secure.force.com/CaseView/articles/Knowledge/How-to-pass-dynamic-data-to-SQL-query-from-UiPath?lang=en_US Thanks, UiPath Quality Team

Thanks

[li.yu (Penny)]

thanks, I tried both ways, but failed.

[li.yu (Penny)]

thanks, I tried, but doesn’t work.

[titatarik (Tarik)]

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