Crestron CT-3000 Specifikace stáhnout pdf (Strana 36)

Crestron e-control Database Manager SW-DBM

36 •• The Database File Installation & Reference Guide — DOC. 5823

Fields

The following sections describe each column (field) in the Queries table.

The Queries table, viewed from the server using its Database | Queries Table command. The Queries

table tell scroller signal blocks how to access the other tables.

The ID column is a unique index number assigned to the query. A matching number

is supplied by the scroller signal block to locate a particular record in the table.

Description

The description column contains a name for the query. If the scroller signal block’s

QueryDescription signal is defined, the value of this field is sent to the control

system when the query is performed (either on signal block enable, or on receipt of a

QueryNumber signal).

During a successive query, the dollar sign character ($) embedded in the description

string has special meaning. (See "Displaying a Successive Query,” page 39, for more

information.)

Table

The table column names the table or tables to be used in the query; in this example,

it is the Addresses table. This column is used to construct the FROM clause of the

SQL request. Any valid FROM clause syntax is acceptable.

Condition

The condition column is for a logical condition; it is used to construct the WHERE

clause of the SQL query. You may not want to select every record from the table.

The condition determines which rows from the table are selected for display on the

touchscreen.

NOTE: This condition, if given, is ANDed with any conditions, if any, that the server is already

imposing on the query.

For example, if you want to select only addresses for Crestron offices in the USA,

you can enter the following logical condition in the condition column:

Country = "USA"

1 2 ... 31 32 33 34 35 36 37 38 39 40 41 ... 93 94

Žádné komentáře

Crestron CT-3000 Specifikace Strana 36