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.

Properties

‌Input

• 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.

Output

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

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

Misc

• 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.