Crestron CT-3000 Spezifikationen PDF herunterladen (Seite 38)

Crestron e-control Database Manager SW-DBM

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

Editing the Table

It is not necessary to have Microsoft Access to edit the Queries table; it can be

edited directly from within the server application. Open the server and select

Database | Queries Table. The Queries Table window opens to display the contents

of the Queries table of the database file named in the COM Settings tab of the

Configuration Options window.

The “data grid” control in this window features the following interactivity for editing

the table:

• For viewing purposes (only), tables can be sorted by clicking on the head of each

column (field).

• Resize the window by clicking and dragging on the lower right corner. Note that

column widths adjust proportionately.

• A column’s width may be adjusted manually by clicking on the far right of its

header and dragging left (to reduce its width) or right (to augment its width).

• Row height can also be adjusted (for all rows at once) by similarly clicking

between rows in the row’s left margin and dragging up or down. (This is useful

to know when a cell’s contents wraps onto additional lines.)

• Records can be deleted by selecting the entire row (by clicking in the row

margin), and depressing the DEL key.

• The information in each cell can be replaced by simply highlighting the cell and

typing over its contents; or you may click once to highlight the cell and again to

precisely place the cursor for editing purposes.

• Records so changed (as evidenced by the little pencil icon in the row margin)

can be changed back by selecting a cell or an entire row (by clicking in the row

margin) and depressing the ESC key.

• Additional records can be entered by scrolling down to the row containing an

asterisk (*) in the left-most column and typing the information.

• Use ENTER to advance to the next cell in a row. The arrow keys also navigate

between cells in a rows, and between rows as well.

• Use the “Requery to show remote edits” button to display changes made

elsewhere since you opened the window. For example, if the database file has

been placed on a file server and has recently been edited from another computer,

you can display those edits by clicking this button.

NOTE: Changes are not actually made until you leave the row (or close the window). When leaving

a row in which you have made a change, you will be asked whether or not to keep (“commit”) the

changes. To accept the changes, click YES; to reject the changes, click NO and then use the ESC

key as described above.

Successive Queries

A successive query is a way of using the touchscreen scroller to “zoom in” to a

desired record by narrowing down choices through a series of scroller picks. The

following simple example helps explain this:

A typical successive query used as a phonebook in a videoconferencing suite

might consist of the following three query levels: (1) Countries, (2) Cities, and

(3) Reps. The user is first presented with a list of countries. Picking a country

from the list results in a new list, this time of cities in that country. Picking a

city results in a third list, this time of reps. Finally, picking a rep displays the

rep’s personnel data record. (Typically, there is a data field that contains a

phone number, to be used by the control system to “speed dial” the call to make

the connection. This field may or may not be displayed.)

1 2 ... 33 34 35 36 37 38 39 40 41 42 43 ... 93 94

Kommentare zu diesen Handbüchern

Keine Kommentare

Crestron CT-3000 Spezifikationen Seite 38

Kommentare zu diesen Handbüchern