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:47am 19

@omer.ozturk
Here’s my sql
All the columns can be null excpet user id and user name

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