Tables

Tables perform a parameterized query of data from a data source.

A connection must be specified which is defined in the knowledge base properties.

Example of defined connections

In an SQL statement, the SELECT to fetch the recordset is specified in an expression.

SQL part of a table definition. Variables in the SQL statement are defined by pipes.

If the statement is given directly as a string, the individual variable components enclosed in pipes are extracted in a parameter table and can be provided with test values for development purposes.

Parameters extracted from the SQL statement and provided with testing values

The result of the query is displayed. If the SQL statement allows, the data records can be edited if necessary.

Result of the query, using the testing values

At runtime, a table-type variable is generated by the table definition. If this variable is accessed, TCE automatically checks the SQL statement for changes and carries out the data query again when a change is detected.

More:

Table