Fig. 28: Overview
The editor page Overview provides the changing of the table name and the database connection also the editing by clicking on the column-, primary key- and index names.
| The following entries are available: | |
|---|---|
| Table name | Name of the table in the database name |
| Static table | When this option is activated, the table has no counterpart in the database. The table can be used habitual in query Queries. Then the wizzard pages Primary Key, and Indicies are not available. The data can only be edited in the table editor. At runtime the data can only be read out |
| Task dependend | All open Tasks will be use independent table contents, if this option activated. If a data row changed in one Task the data of the other tasks are in original state. All tables will share the same data if the option is deactivated. Only usable if static table |
| Connection file path | Contains the name of the Database connection |
| Schema | Selection of a Databas shema, that can be assigned to the table |
| Comment | Allows to add a description of the table |
| Indicies | List of the names of the indicies. By selecting the button the editor page Indicies will be opened |
| Primary key name | The name of the primary key. By selecting the button the editor page Primary key will be opened |
| Table columns | List of the names of the table columns. By selecting the button the editor page Table columns will be opened |
Table Editor