# Execute Query Parameter **URL:** \ **Category:** Help\ **Tags:** database, question, activities\ **Created:** [December 15, 2019, 8:48pm UTC](https://forum.uipath.com/t/execute-query-parameter/177532 "2019-12-15T20:48:38Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Ricardo\_Franco](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/ricardo_franco/32/125641_2.png) [@Ricardo\_Franco](https://forum.uipath.com/u/Ricardo_Franco)\ **Post date:** [December 15, 2019, 8:48pm UTC](https://forum.uipath.com/t/execute-query-parameter/177532/1 "2019-12-15T20:48:38Z")
When I run the Query my parameter doesn`t send his value. What am I doing wrong? ![query](https://global.discourse-cdn.com/uipath/original/3X/8/3/83158ed5e000dfa15e064309fdc73523253feb7b.png) ---
**Author:** ![balupad14](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/balupad14/32/462142_2.png) [@balupad14](https://forum.uipath.com/u/balupad14)\ **Post date:** [December 15, 2019, 8:57pm UTC](https://forum.uipath.com/t/execute-query-parameter/177532/2 "2019-12-15T20:57:48Z")
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](https://forum.uipath.com/t/insert-sql-with-variable-parameter-giving-error-in-executenonquery-activity/101739/8): > > 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](https://global.discourse-cdn.com/uipath/original/3X/c/8/c87b8b0ed32608dfd357ae7145ae4b15257a6fd7.zip) (2.7 KB) Regards Balamurugan.S Regards Balamurugan.S ---
**Author:** ![Ricardo\_Franco](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/ricardo_franco/32/125641_2.png) [@Ricardo\_Franco](https://forum.uipath.com/u/Ricardo_Franco)\ **Post date:** [December 15, 2019, 9:55pm UTC](https://forum.uipath.com/t/execute-query-parameter/177532/3 "2019-12-15T21:55:16Z")
It didn`t work ---
**Author:** ![balupad14](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/balupad14/32/462142_2.png) [@balupad14](https://forum.uipath.com/u/balupad14)\ **Post date:** [December 15, 2019, 9:59pm UTC](https://forum.uipath.com/t/execute-query-parameter/177532/4 "2019-12-15T21:59:39Z")
What happened ? ---
**Author:** ![Ricardo\_Franco](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/ricardo_franco/32/125641_2.png) [@Ricardo\_Franco](https://forum.uipath.com/u/Ricardo_Franco)\ **Post date:** [December 15, 2019, 10:05pm UTC](https://forum.uipath.com/t/execute-query-parameter/177532/5 "2019-12-15T22:05:58Z")
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 ---
**Author:** ![balupad14](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/balupad14/32/462142_2.png) [@balupad14](https://forum.uipath.com/u/balupad14)\ **Post date:** [December 15, 2019, 10:09pm UTC](https://forum.uipath.com/t/execute-query-parameter/177532/6 "2019-12-15T22:09:28Z")
Hi @Ricardo_Franco, Can you send me the xmal ? Regards Balamurugan.S ---
**Author:** ![Ricardo\_Franco](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/ricardo_franco/32/125641_2.png) [@Ricardo\_Franco](https://forum.uipath.com/u/Ricardo_Franco)\ **Post date:** [December 15, 2019, 10:16pm UTC](https://forum.uipath.com/t/execute-query-parameter/177532/8 "2019-12-15T22:16:55Z")
[Main.xaml](https://forum.uipath.com/uploads/short-url/51OJ7MS1dIdvjKzVm2Y63NAD0w.xaml) (4.1 KB) ---
**Author:** ![Ricardo\_Franco](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/ricardo_franco/32/125641_2.png) [@Ricardo\_Franco](https://forum.uipath.com/u/Ricardo_Franco)\ **Post date:** [December 15, 2019, 10:19pm UTC](https://forum.uipath.com/t/execute-query-parameter/177532/9 "2019-12-15T22:19:20Z")
I m using mysql odbc. Did I need some extra package installation? ---
**Author:** ![balupad14](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/balupad14/32/462142_2.png) [@balupad14](https://forum.uipath.com/u/balupad14)\ **Post date:** [December 15, 2019, 10:22pm UTC](https://forum.uipath.com/t/execute-query-parameter/177532/10 "2019-12-15T22:22:28Z")
Hi @Ricardo_Franco, Can you please test the connection in odbc like below. ![image](https://global.discourse-cdn.com/uipath/original/3X/3/b/3bc1fbf5285787e89fe77b9bf78847a069dd1405.png) Regards Balamurugan.S ---
**Author:** ![Ricardo\_Franco](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/ricardo_franco/32/125641_2.png) [@Ricardo\_Franco](https://forum.uipath.com/u/Ricardo_Franco)\ **Post date:** [December 15, 2019, 10:22pm UTC](https://forum.uipath.com/t/execute-query-parameter/177532/11 "2019-12-15T22:22:51Z")
the connection works ---
**Author:** ![Ricardo\_Franco](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/ricardo_franco/32/125641_2.png) [@Ricardo\_Franco](https://forum.uipath.com/u/Ricardo_Franco)\ **Post date:** [December 15, 2019, 10:24pm UTC](https://forum.uipath.com/t/execute-query-parameter/177532/12 "2019-12-15T22:24:03Z")
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” ---
**Author:** ![balupad14](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/balupad14/32/462142_2.png) [@balupad14](https://forum.uipath.com/u/balupad14)\ **Post date:** [December 15, 2019, 10:31pm UTC](https://forum.uipath.com/t/execute-query-parameter/177532/13 "2019-12-15T22:31:38Z")
Hi @Ricardo_Franco, If you run this statement , it works well ? “INSERT INTO invoices(name) VALUES (‘“& variable &”’)” Regards Balamurugan.S ---
**Author:** ![Ricardo\_Franco](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/ricardo_franco/32/125641_2.png) [@Ricardo\_Franco](https://forum.uipath.com/u/Ricardo_Franco)\ **Post date:** [December 15, 2019, 10:42pm UTC](https://forum.uipath.com/t/execute-query-parameter/177532/14 "2019-12-15T22:42:21Z")
yes. I just can`t use the parameter. Regards