Database Non Query

This action can be used to execute a non query to a database, such as INSERT, UPDATE and DELETE statements, conection and returns an integer value representing the number of affected rows.



  • Command: The SQL Command which will be executed on the given tatabase connection;

  • Database Connection: The DatabaseConnection object which will be used to interract with the SQL Server.


  • Result: The resulting int32 object returned by the query.

Note: This object must have the Variable Type set int32.


  • Display Name: action display name in your implementation project.

  • Wait Before: number milliseconds robot to wait before executing the action.

  • Wait After: number milliseconds robot to wait until moving to the next action.

  • Abort on Error: True/False.

  • Retry Times: Specifies the number of times to retry an action if it doesn't end successfully. Default value 0 (no retry); Use -1 if you want to retry indefinitely.

Use Case

Potential Use Cases

  • Directly Insert/Delete enteries in the invoices database based on predefined criteria.

Last updated