Configuring Database Queries
You can configure queries to perform more advanced functions with SQL statements to work with data from external databases.
To configure database queries:
1. Go to Edit > Datasets > Queries.
2. Enter or select information, as needed.
Column | Description |
Name | Enter a name for the query. The system lets you know if the name is not valid. |
DB | Select the database configuration. |
SqlStatement | Enter the query using SQL syntax. |
Mapping | Click ... to select the tags that you want to populate with data from the query 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 queries as you need.
Getting the query contents
The runtime access to the table contents is executed automatically when the query is mapped to a DataGrid object, see
Configuring a DataGrid Window.
You can also get the query contents or perform operations on the query, using the runtime
properties for the Dataset.Query object, see http://www.tatsoft.com/help/fs-2014/runtime/index.html.