Execute Query Parameter

[Ricardo_Franco]

When I run the Query my parameter doesn`t send his value. What am I doing wrong?

[balupad14 (Balamurugan)]

Hi @Ricardo_Franco,

Here is the sample that to pass the parameter in the sql server.

Insert SQL with variable / parameter giving error in ExecuteNonQuery activity

Hi @ramawat, I made a test what @Pablo_Sanchez mentioned with a little table. It is working fine. can you attache the table script and your insert query as a zip file. May be it helps to do the analysis. But any way, Here I have attached xaml and table for your reference. SqlServer.zip (2.7 KB) Regards Balamurugan.S

Regards
Balamurugan.S

[Ricardo_Franco]

It didn`t work

[balupad14 (Balamurugan)]

What happened ?

[Ricardo_Franco]

My query “INSERT INTO invoices(name) VALUES (@name)” the “@name” its a parameter. And when i execute the query it can`t access the @name value that i set in the parameter as it is in the picture that i post

[balupad14 (Balamurugan)]

Hi @Ricardo_Franco,

Can you send me the xmal ?

Regards
Balamurugan.S

[Ricardo_Franco]

Main.xaml (4.1 KB)

[Ricardo_Franco]

I m using mysql odbc. Did I need some extra package installation?

[balupad14 (Balamurugan)]

Hi @Ricardo_Franco,

Can you please test the connection in odbc like below.

Regards
Balamurugan.S

[Ricardo_Franco]

the connection works

[Ricardo_Franco]

I can send value to the database. The issue is that i can`t get the values of the parameter when i call it like this “@parameterName”

[balupad14 (Balamurugan)]

Hi @Ricardo_Franco,
If you run this statement , it works well ?

“INSERT INTO invoices(name) VALUES (‘“& variable &”’)”

Regards
Balamurugan.S

[Ricardo_Franco]

yes. I just can`t use the parameter.

Regards