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

LABELVIEW User Guide

The Table lookup data source

Command: Data sources > Table lookup > Add

The Table lookup data source contains a list of data sources you have created. The data source values are the

result of searches carried out in databases other than those linked to the current document.

Searches are carried out in one or more database fields. Data is extracted from one of the record fields found

(called the "result field").

Defining the properties of a Table lookup data source

Command: Data sources > Table lookup > Table lookup name >Properties.

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

Note: To create 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.

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

create your query.

Standard creation mode

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

4. In the Select result field list, select the field whose value will be transferred into your variable.

5. Click

to add a row.

6. Select the field in the external table on which the search will be carried out.

7. Select the current document variable containing the search value.

8. Click the Test button to display the result.

dvanced SQL creation mode

3. Click SQL mode.

4. Enter your query in SQL format.

- or -

Click SQL Query Builder to access Query Builder. This provides an easy-to-use interface for building

SQL database queries. You can create new requests graphically orinsert existing requests in your

document.

5. Click the Test button to display the result in the Query dialog box.

1 2 ... 27 28 29 30 31 32 33 34 35 36 37 ... 45 46

No comments

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