Table

The structure element table has the following properties and functions:

Update of the data query

Attempt to save the changes to the query result in the database

SQL

Property	Description
Connection	Selection of a database connection ID, which was previously defined in the knowledge base properties.
SQL	Specification of an expression for the SQL SELECT statement to query the recordset.

Parameter

Property	Description
Parameter	Extracted parameters in the SQL statement framed with pipes.
Value	Value replacing the pipe-framed parameter when executing the statement at design time.

Result

TCE tries to prepare the data content appropriately. Binary data is not displayed.

Individual fields can be edited, and data records can be added and deleted if necessary. The key columns of the table, if any, are shown with a yellow background.

At runtime, the structure element is transferred to a variable of the type Table.

When this variable is accessed, the statement is automatically checked for changes and executed again if necessary.

The currently executed statement can be queried using the variable's source attribute function.