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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://doc.sysdevmobile.com/kalipso5/developing/form/actions/actions-description/group-database/insert.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.