TEKLYNX Labelview 9.1 Basic, SW Key + 1Y SMA, ML User's Guide download pdf (Page 30)

LABELVIEW User Guide

For each

of these creation modes:

 The data source created is automatically displayed under the selected data source.

 The application gives the data source a default name.

Note: Brackets {} cannot be used in a variable name.

This procedure applies to all data sources, except variables from the Database data source. To create a

database variable, you need to create a query.

 Categories and sub categories can be added under the selected data source, except for the Database

data source.

Note: To create categories and sub categories, right-click one of the data sources and select Add category.

The Database data source

Command: Data sources > Database > Create/Modify Query.

The Database data source contains a list of variables. These variables are populated by data from queries or

ASCII tables.

Note: Data sources keep the names of the fields that populated them.

Database variables cannot be renamed because they are linked to the database fields names.

Creating a query

Command: Data source > Database > Create/Modify Query

1. Select the data source from the Select data source list.

Note: For a new data source, click the New data source button. This gives you the option of using the Wizard

or choosing between an ODBC or OLEDB data source.

By default, Standard creation mode is activated. You can use Advanced SQL creation mode to create your

query.

Standard creation mode

2. In the Select table list, select the table where the search is to be carried out.

The Include table names option, allows you to display the table names in the list of fields.

3. In the Elements list, select the elements you want to display.

4. In the Select fields list, select the fields for the selected table.

1 2 ... 25 26 27 28 29 30 31 32 33 34 35 ... 45 46

No comments

TEKLYNX Labelview 9.1 Basic, SW Key + 1Y SMA, ML User's Guide Page 30