Upgrade SQL datatable

[BPALC (Frederic)]

Hello,
I try to upgrade datatable in SQL.
I “execute query” to connect to my table, i make a “for each row” to read all the row in the datatable.
And i try to “execute a query” to upgrade a column in my datatable like that
“UPDATE ROBOT_DOS Set DT_FIN = GETDATE() Where ID_DOS = ID_DOS2”
where ROBOT_DOS is the table DT_FIN the column, ID_DOS another collumn and ID_DOS2 a variable in uipath who is the value of ID_DOS.
Can you help me ?
Thank

[BPALC (Frederic)]

I have this error

[vvaidya (Vinay Vaidya)]

You need to refer this link and regarding error i think you should use something below

JsonConvert.DeserializeObject<IEnumerable<**Type**>>(Data)

How to query data from a SQL database

[BPALC (Frederic)]

I finally found the solution.
I use the query :

"UPDATE ROBOT_DOS Set DT_FIN = GETDATE() Where ID_DOS = " + ID_DOS2.ToString

Thank for your help.

[Cosmin_Ion_Nicolae (Ion Nicolae)]

Hello.
Just a small comment if you are working with databases.

That error is returned each time you have a problem with an Database Activity. If the SQL query has problems and you want to check that you can go to the output panel or the logs and there you should be able to see the actual SQL error.