I am using Execute non query activity to insert or update data into a datatable. All data appears except for one column the data is not inserted or updated. I do not receive any errors from Ui Path. When I use the exact same activities in a single UiPath Project and not in my State Machine it works. …

instead of inline query you can use stored procedure then it will easy for you,i think and in command type you can change commantype:“Text” to “StoredProcedure” it may helps you Create Procedure Sp_test ( @var1 varchar(50)=‘’, @var2 varchar(50)=‘’, @var3 varchar(50)=‘’, @flag varchar(10)=‘’ ) …

Hi Sampad, thanks for your advice. Can you explain me in more detail what “Stored/Procedure” does? What would i need to change in the query? I cant find a helpful link to it. Thanks

Hi LiB, For Database/Backend what you used?Sql Server/Oracle If it is sql server,log in to sql server Create StoredProcedure by using this below query Create Procedure Sp_test ( @var1 varchar(50)=’’, @var2 varchar(50)=’’, @var3 varchar(50)=’’, @flag varchar(10)=’’ ) as begin if(@flag=‘I…

HI @sampad .Net SqlClient Data Provider : Procedure or function ‘update_atmcomplaints’ expects parameter ‘@cardnumber’, which was not supplied. i am getting this error create procedure update_atmcomplaints ( @cardnumber varchar(100), @remarks varchar(100), @status varchar(100) ) as begin …

Hi, Can you check this .It may help you [image] Update in database Academy Feedback Hi @arjun27 , I have tested your situation to my side . I identified that have to change the command type is to “storedprocedure”. If i set it as “Text”, Yes I am getting error what you…

Thanks @balupad14 For the help Thanks Arjun

Hello guys I have a similar problem. I have a Execute NonQuery activity that updated records on database, after this I need use a first NonQuery parameter to update in another database table. I add other Execute NonQuery with a second store procedure. When run the robot, the first query isn’t update…

Execute Non Query not inserting/updating all values

Help

balupad14 (Balamurugan (BalaReva)) March 12, 2018, 7:16pm 7

Hi,
Can you check this .It may help you

Regards
Balamurugan.S

Topic		Replies	Views
Execute Query Stored Procedure Error Activities activities , question , script , executequery	4	1553	March 24, 2022
Update in database Academy Feedback	21	6285	April 10, 2018
Error While inserting data in stored procedure Studio datatable , excel , activities , studio , sql-stored-procedure	6	469	February 8, 2024
Stored proc Help	6	2680	January 26, 2024
SQL database Query - Execute Non Query/Query Help	4	7870	January 23, 2019

Execute Non Query not inserting/updating all values

Related topics