# 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<br>

![](https://649489153-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MSSr3DfBuOYIkk2T9ec%2Fuploads%2FHjX9DRc5Vxiq5A90cnZv%2Fimage.png?alt=media\&token=0bf5cbe3-0a6d-43b2-86fb-479707e1a438)

### ‌Input

![](https://649489153-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MSSr3DfBuOYIkk2T9ec%2Fuploads%2FNywzeiqPcsnrSNFVrPqT%2Fimage.png?alt=media\&token=71beb9b5-6ae6-4819-94a9-bc071715242c)

* **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

![](https://649489153-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MSSr3DfBuOYIkk2T9ec%2Fuploads%2FpRxfwvv4PZPStEJhYty9%2Fimage.png?alt=media\&token=9dcefc96-1950-4401-8c3d-fbaf2309763e)

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

{% hint style="info" %}
**Note:** This object **must** have the **Variable Type** set **int32.**
{% endhint %}

### Misc

![](https://649489153-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MSSr3DfBuOYIkk2T9ec%2Fuploads%2F9YEnqXvXONhZoaXuN5IV%2Fimage.png?alt=media\&token=e8504a99-d4da-44b6-88bb-2cac396ef788)

* **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.&#x20;
* **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** <a href="#potential-use-cases" id="potential-use-cases"></a>

* Directly Insert/Delete enteries in the invoices database based on predefined criteria.&#x20;

{% embed url="<https://youtu.be/nS1VZIWhAJg>" %}