
Description | With this action you can write a record into a table of the database. |
Required licence | Database Feature |

1 | Database | Select the database into which you want to insert the record. |
2 | Table | Select the table in which you want to insert the record. |
3 | Mapping | In this table you can assign a value to the columns of the database table. Three options are available for this purpose. Default value: With this option, no value is passed from the DataSuite to the database, but the value is set by the database itself. This option should be used for the primary key of the table. Variable: You can use an assigned variable (e.g. from the PLC). The value is transferred as an SQL parameter and the data type is not changed. Text: You can enter a text, this will be transferred to the database as a string. This text can also contain variables. The values of the variable are also converted into a string. |