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

KavinduPerera (Kavindu Perera) October 20, 2022, 8:18am 10

hi @omer.ozturk
Actually I’m new to uipath and your support is a big help now i tried your new code but it’s a new error popping up in runtime.
Sorry for the trouble

now it comes to this

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