Execute Query Parameter

Help
, ,
1

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

query
query1280×940 48.7 KB

2

Hi @Ricardo_Franco,

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

Regards
Balamurugan.S

3

It didn`t work

4

What happened ?

5

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

6

Hi @Ricardo_Franco,

Can you send me the xmal ?

Regards
Balamurugan.S

8

Main.xaml (4.1 KB)

9

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

10

Hi @Ricardo_Franco,

Can you please test the connection in odbc like below.

image
image1100×586 41.6 KB

Regards
Balamurugan.S

11

the connection works

12

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”

13

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

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

Regards
Balamurugan.S

14

yes. I just can`t use the parameter.

Regards