Unable to execute update query in run query activity with parameters

Help Studio
, ,
1

Hello,
I am using run query activity to execute update query while passing dynamic value as parameters but it is throwing error.(Excel as DB)
Query Used:
“Update [Sheet1$]
set [TestResult] = @Argument1
Where [ExpectedResult] =@Argument2”

Getting below error:
“Run query: ERROR [07002] [Microsoft][ODBC Excel Driver] Too few parameters. Expected 2”.

2

Hi @poonampandire95

Instead of using the parameters to pass the values you can use variables also I tested it works like this

image
image907×571 20.4 KB

Your query will look like this

“Update [Sheet1$]
set [Second] = ('” + P1 + “‘)
Where [Second] =(’” + P2 + “')”

More like this

“Update [Sheet1$]
set [TestResult] = ('” + P1 + “‘)
Where [ExpectedResult] =(’” + P2 + “')”

Hope this helps :slight_smile:

3

Hello @AJ_Ask
Now its working.
Thank you for the help :slight_smile: .

4

If my reply helped. Please accept it as a solution so that it can help others also. :slight_smile:

5

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