Hello, im trying run a execute non query activity with an insert query into my database like below, “INSERT Into user_details(User_ID, User_Name, User_Role, NIC, Mobile_Number, BranchCode) VALUES ('”+User_ID+“‘,’”+User_Name+“', '”+User_Role+“', '”+NIC+“', '”+Mobile_Number+“', ‘“Branch_Code”’);” i…

I updated it a little bit too. "INSERT Into user_details(User_ID, User_Name, User_Role, NIC, Mobile_Number, BranchCode) VALUES ('" + User_ID + "','" + User_Name + "','" + User_Role + "','" + NIC + "','" + Mobile_Number + "','" + Branch_Code +"');" I hope it works :slight_smile: Regards Ömer

Writing Insert Query in uipath studio

Help Studio

omer.ozturk (Ömer Öztürk) October 20, 2022, 8:43am 17

@KavinduPerera,

No, you dont have to give your variables to parameter section. Can you share the screenshot of your sql query part?

Regards
Ömer

Topic		Replies	Views
String constants must end with a double quote Studio	2	2439	June 29, 2021
Execute NonQuery issue - quotes Help	6	1623	October 29, 2018
Using Variables in a SQL Query - String Commands must end in Double Quotes Studio datatable , studio , question , sql , activities_panel , variables_management , sql-stored-procedure , fetch-sql-data	11	3767	April 14, 2022
How to pass query from asset to execute query activity Help activities	12	1598	July 4, 2019
Pass in user input to sql query execute query Help studio	3	2306	April 19, 2018

Writing Insert Query in uipath studio

Related topics