Execute Query Parameter

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

1 Like

Hi @Ricardo_Franco,

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

Regards
Balamurugan.S

1 Like

It didn`t work

1 Like

What happened ?

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

1 Like

Hi @Ricardo_Franco,

Can you send me the xmal ?

Regards
Balamurugan.S

Main.xaml (4.1 KB)

1 Like

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

1 Like

Hi @Ricardo_Franco,

Can you please test the connection in odbc like below.

Regards
Balamurugan.S

1 Like

the connection works

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

1 Like

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

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

Regards
Balamurugan.S

1 Like

yes. I just can`t use the parameter.

Regards