Add variables to the DataBase data source
Assign a name for the variable and select the “Data type“. Click on “Add” to create the variable. The window remains open to create further variables.
“Close” the window to end the input.
The value of the “Key” field is used to identify the row of the table from which the value of the “VAR_VALUE” column is to be read as the value for the variable.
The variable for the DataBase data source has been successfully created and can now be used.
In contrast to the file system data source, the variables for the DataBase data source cannot be created just like that, but the name of the variables must be entered in the SQL server in order to be able to query them.
You can find out how to prepare the database in the article on creating DataBase data sources
DataBase address syntax for quick entry
DataBase variables can also be added with a quick entry.
A variable with a single field entry can be created here using the correct syntax.
In general, the following syntax applies to DataBase addresses:
- [Datentyp].[Key]
Data types:
| Abbreviation | Description |
| X | Boolean |
| I1 | Byte |
| UI1 | UByte |
| I2 | Short |
| UI2 | UShort |
| I4 | Integer |
| UI4 | UInteger |
| I8 | Long |
| UI8 | ULong |
| F | Float |
| D | Double |
| S | String |
| V | Variant |
