Run query - output datatable empty even though record is updated

[postwick (Paul Ostwick)]

I converted a project to Windows compatibility and upgraded UiPath.Database.Activities to 1.7.1. The previous version had an output of the number of records updated. The new version has an output of a datatable of records updated. So now after the query runs I am looking at DT_UpdatedRecords.Rows.Count to verify a row was updated, but it’s always coming back 0. I verified in the database that the row is being updated. The database is SQL Server.

EDIT: why did you take away the “number of records updated” output? This is essential to confirming that the update query updated the expected number of records. With no output, there is no way to confirm.

[supermanPunch (Arpan)]

Hi @postwick ,

I believe you have used the Execute Query activity or Run Query activity. If so, the Activity only outputs a Datatable if the Query returns/outputs a value/table.

For the Insert/Update commands, in the Run Query activity we will not receive the affected records, we will receive the affected records when used with Execute Non-Query or Run Command activity.

Run Query Activity :

Run Command Activity :