Bulk Update: No value given for one or more required parameters

[Tadas (Tadas cirklys)]

Hello,

I am trying to update my access database with ‘Bulk Update’ activity, but I keep getting this error: Bulk Update: No value given for one or more required parameters.
Activity is set up as shown bellow:

The goal here is as follows:
-get data table from access DB
-update a status column
-update access data base with new values of status column.
may be there is another approach to this?

[supermanPunch (Arpan)]

Hi @Tadas ,

I am not really sure if we would require to get the Datatable, Update and Update the Table in Database. Instead of this, Could we Try to Update the Values in the Database Directly using Execute Non Query Activity ?

Is there a Reason why you have opted for this method ?

[Tadas (Tadas cirklys)]

I guess the reason would be the lack of experience how would one use execute non query activity for this particular task?

[supermanPunch (Arpan)]

@Tadas , If we do have to Update Column Values based on a Condition we could use the Below Syntax to create the Sql Query and use it in the Non Execute Query Activity :

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

Example :

UPDATE Sheet1
SET column1 = value1, column2 = value2
WHERE column1<10;

Some other Posts Supporting the Query :

How to Remove timestamp from DateTime Variable

Hi Rajesh, I think you don’t need datetime variable in uipath to get data from sql query only date variable of type string will work. you can pass string value to filter this for example your scenario your query UPDATE dbo.TableName SET Column1=0 WHERE MemberID=‘xxxx/’ AND DateOfService=‘2021-05-22’ consider only this part of query AND DateOfService=‘2021-05-22’ "AND DateOfService="+"'"+DateStringVariable+"'" the above code you will use to filter data using execute non query activity …

[Tadas (Tadas cirklys)]

Great thanks a lot, that worked!