Configuring Database Tables Access
If you are using an external database as a data source in your application, you can specify which table to use from the database.
To configure database tables:
1. Go to Edit > Datasets > Tables.
2. Enter or select information, as needed.
Column | Description |
Name | Enter a name for the table configuration. The system lets you know if the name is not valid. |
DB | Select the database configuration. |
TableName | Select the table name. |
WhereCondition | Specify parameters to filter the data using SQL syntax. E.g. “ColumnName = {@tag.tagInt}” |
Access | Select the access permissions for the table. |
Mapping | Click ... to select the tags that you want to populate with data from the first row of the table with data from specific columns. |
Description | Enter a description for the table configuration. |
[Other columns] | For definitions of other columns that are available in many tables, see Common Column Definitions. |
3. Continue adding as many table configurations as you need.
Reading and writing the table contents
The runtime access to the table contents is executed automatically when the table is mapped to a DataGrid object, see
Configuring a DataGrid Window.
You can also get the table contents or perform operations on the tables, using the runtime
properties for the Dataset.Table object, see http://www.tatsoft.com/help/fs-2014/runtime/index.html.