# Insert

Inserts a record on the specified Database Table.

Action available for the following operating systems:

![](https://3821468174-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LrTlA1suFa5N48x_83N%2F-MAlPVpH3WRwBy16c7JY%2F-MAlQBZuuTnc6hyzKSVQ%2Fimage.png?alt=media\&token=5c9534b7-ca05-4ac4-b408-2207cd5a5295)

### Parameters

* **Table** - Database Table where to insert the new record.
* **Values** *\<string> or \<numeric> -* Value to assign to the specified *Column*. This expression will be evaluated accordingly with the *Type* column.
* **Ignore Database Masks -** If you've defined a *Output* Mask for the specified *Column* in the *Table* properties and:
  * This option is **checked** - You must specify the value in the Kalipso format.
  * This option is **unchecked** - You must specify the value in the Mask format.
* **Duplicate Quotes** - Check this option to automatically duplicate the *quote* (') character on the *Values* specified, to correctly insert the record in the database. For further information take a look at the examples below.

### Usage

This function generates an SQL Insert operation that exists in every SQL database, and is used to insert a record in the database.

Consider you want to insert records in the following Database Table:

| **Products** |          |           |
| ------------ | -------- | --------- |
| **Code**     | **Name** | **Stock** |
| *empty*      | *empty*  | *empty*   |

#### Example 1

| **Table**            | Products |                      |
| -------------------- | -------- | -------------------- |
| **Columns**          | **Type** | **Values**           |
| Code                 | Numeric  | 100                  |
| Name                 | String   | "Coca Cola 'Updated" |
| Stock                | Numeric  | 400                  |
|                      |          |                      |
| **Duplicate Quotes** | No       |                      |

**Result:**

| **Products** |          |           |
| ------------ | -------- | --------- |
| **Code**     | **Name** | **Stock** |
| *empty*      | *empty*  | *empty*   |

{% hint style="warning" %}
It originates a syntax error because parameter **Duplicate Quotes** is disabled, therefore no record is inserted.
{% endhint %}

#### Example **2**

| **Table**            | Products |                      |
| -------------------- | -------- | -------------------- |
| **Columns**          | **Type** | **Values**           |
| Code                 | Numeric  | 100                  |
| Name                 | String   | "Coca Cola 'Updated" |
| Stock                | Numeric  | 400                  |
|                      |          |                      |
| **Duplicate Quotes** | Yes      |                      |

**Result:**

| **Products** |                    |           |
| ------------ | ------------------ | --------- |
| **Code**     | **Name**           | **Stock** |
| 100          | Coca Cola 'Updated | 400       |