Description | With this action you can read several records in one operation from a table or view of a database. |
Required License | Database Feature |
Please note:
Custom database queries as a view: If you use your own complex database queries over several tables (join), create them as a view in the database. You can then use them in the DataSuite and enter a Where condition.
Please note:
Clear arrays before requesting data records: Only the existing data records from the database are written into the variables. If, for example, the database supplies 50 data records and the arrays can contain 100 entries, only the first 50 are written. The values in the entries 51-99 remain unchanged. You should therefore delete all contents from the arrays before requesting the data. You can also have the number of data records written into a variable.
1 | Database | Select the database you want to read from. |
2 | Data Source | You can either read from a table or view (predefined select query). |
3 | Table/View | Select the desired table or view. Depending on point 2. |
1 | Data source structure | Select the option here that corresponds to your data structure. Array of structures: E.g. one “Array[0..99] of Struct”. One array per value: E.g. several “Array[0.99] of Byte”. Only the existing data records from the database are written into the variables. If, for example, the database supplies 50 data records and the arrays can contain 100 entries, only the first 50 are written. The values in the entries 51-99 remain unchanged. |
Array of structures #
Select this option if you are using in array where each record is stored as a structure.
1 | Structure variable | Select a variable of the Array of Struct type. |
2 | Mapping | After you have selected a table or view, all columns are loaded from the database and you can assign each of them to a variable within your structure variable. If you do not want to write a column into a variable, you can simply deactivate it using the switch. |
One array per value #
Select this option if you use a separate array for each parameter.
1 | Mapping | After you have selected a table or view, all columns are loaded from the database and you can assign each of them to an array variable. If you do not want to write a column into a variable, you can simply deactivate it using the switch. |
1 | Where | A database table usually consists of many records. You can limit the selection with the where condition. The condition must be specified in the SQL syntax of your database. You can also use variables in the condition (see Use variables). |
1 | Number of records | Only the existing number of records is written into the variables. If arrays are larger, the remaining entries are not overwritten. With this option you can write the number of records actually written in a variable. |
1 | No data available | If the query does not return any data records, you can set at this point whether the trigger should then be continued without writing data into the variables or whether an error is issued. |