How to send back a row to and SQL server?

Help
,
1

Hi everyone,

I have a qeustion. I want to send a row back to a sql server. So i thought i make an for each row and then with the right activity ( i dont know wich one). My robot is going to do something in the ERP-system and get the data from a SQL server. When When the robot has done his work, he needs to send back the date of today with the correct ID number? (ID=ID, send current date in specific column) My first question, is this possible with uipath and wich activity do i need to use to solve my problem?

I hope u understand my question and thanks for helping me!

2

If you put the row you want to send back in a DataTable this seems to be what you are looking for:

3

Thanks for your reaction!

I saw this activity also, but i saw some instruction video’s of this activity but in the exemple they use you can only send the whole datatable. Is it possible to only send a date to a specific column?

For exemple in uipath you can say: IF: ID.equels.ID then do this.

4

Maybe i forgot to say it. But the SQL server has already a datatable with alot of ID’s but by the correct ID i want the Date so i know the robot has done this row.

5

Hi @peterlimonade,

For UPDATE, INSERT, and DELETE statements, it is necessary to use the Execute Non Query activity https://docs.uipath.com/activities/docs/execute-non-query

In your case, if you want to update one row, you should use the INSERT SQL transaction.
Here you can find an example:

sol
sol1140×718 28.5 KB

Hope this helps
Best regards,
Marius

6

Thank you!

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.