# INSERTDATA

#### Syntax <a href="#syntax.22" id="syntax.22"></a>

**INSERTDATA**(*table*)

* *table* - a table widget which contains the datasets which should be inserted into the data source - ***Value type**: table widget*

#### Remarks

* *table* must be a table widget which has a database connection assigned, including:
  * a connnection to a relational database
  * (optional) a specified database schema
  * a specified database table
  * specified database columns
    * with specified key columns (“Key” property) - optional
    * If columns are not specified, they are added with a null value.
* The logic of the insertion is as follows:
  * If there is already a dataset with the specified key column values in the db table, the exisiting dataset will be overwritten.
  * If not, the dataset is added as new dataset.
  * If no key column is specified, all datasets are added.
* The widget which calls the INSERTDATA function does not need to be connected to the data source.

#### Examples

*Example 1 - Change the whole database table*

The WineList table is filled with the function GETDATA, showing the data from the WineList database table. The column Name has the property "Key column".

<figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-364bc02ed47d355eaabaf9c7654b0a09b1717ba3%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>

If the content of this table should be changed, a single call of the INSERTDATA function is sufficient, using the table as parameter.

<figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-027494e3677888bb2eab1774a27d0ebedcadfc8b%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>

*Example 2 - Add a single row*

The content of the database table from example 1 can be changed by another table as well. Here a single new dataset should be added. For this, the settings in the Connection tab should be the same as for the *WineList* table.

<figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-1560225cf95ff24e229fdc4e5034d4cfb1ff23e9%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>

Please note that the second table is not filled with the GETDATA function. Instead, it can be filled with any dataset content, e.g. manually or using other formulas.

Now any single or multiple datasets can be added or changed, by clicking on the *AddWine* button.

<figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-8047ff39c20fcd8dbcbb808add41dc500fe4ec99%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>

*Example 3 - Add single values*

If only a single value should be added or changed for a dataset, the other database columns do not to be specified.

<figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-d79f57727ce26480d65d081e0943acd587405974%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>