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

Help Studio
, ,
1

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
11030×616 29.9 KB

Parameter
Parameter697×126 4.83 KB

2

Hi @li.yu

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

cheers

3

Hello @li.yu

Please check the below Similar post.

Thanks

1 Like
4

thanks, I tried both ways, but failed.

5

thanks, I tried, but doesn’t work.

6

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

7

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

1 Like
8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.