Property

Description

SQL

A SELECT SQL statement used to determine class name and class properties.

Connection

The ID of the database connection. The ID is set in the Knowledge Base properties.

Key

Name of the column in the SQL statement to be used to generate the ODBC class names. The SQL statement must ensure that only unique values are returned in this column.

DB description

If you want to fill the multilingual name of the generated ODBC classes, the name of the column of the SQL statement, which represents the respective label in the language shown, must be entered here.

DB Validity

If the validity of the generated ODBC classes is to be filled, the name of the column of the SQL statement, which represents the respective validity (from/to) must be entered here. The type of column in the SQL statement must be of type DATE or TIMESTAMP or similar data type.

Remarks

Developer comments