> For the complete documentation index, see [llms.txt](https://doc.sysdevmobile.com/kalipso5/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://doc.sysdevmobile.com/kalipso5/developing/form/actions/actions-description/group-database/insert.md).

# Insert

Inserts a record on the specified Database Table.

Action available for the following operating systems:

![](/files/-MAlQBZuuTnc6hyzKSVQ)

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