Crestron
e-control Mail SW-MAIL
42
••
The e-Mail Database Tables
Installation & Reference Guide — Doc. 5798
Signal log search window.
Searches can be performed with and without case sensitivity by checking the
Match Case
option. When the window opens this option is unchecked —
meaning that the search algorithm disregards the upper- and lower-case status
of the characters in the search key.
Also when the window opens, the search direction is set to
Forward to end
meaning that the search will begin with the signal on the highlighted line and
will continue to the end of the log. The other options are
Forward from top
which searches the entire log;
Backward to top
which searches beginning with
the signal on the highlighted line and continuing back to the beginning of the
log; and
Forward to end then wrap around from top
which also searches the
entire log starting with the signal on the highlighted line.
The e-Mail Database Tables
The supplied sample e-Mail Database file (
maildemo.mdb
) contains 22 tables:
Table
Viewable from
Server
Description
Queries
P
Table used by scrollers to make
queries into
eMail_xxx
tables.
eMail_Msg
eMail_Addr
eMail_Subst
P
P
P
Tables of messages, addresses, and
substitution text used by all
e-mailer signal blocks.
Inbox1
to
Inbox5
msg1
to
msg5
(
rcpt1
to
rcpt5
)
Tables for five IN boxes and five
message displays used by scroller
signal blocks referenced by up to
five separate e-mailbox signal
blocks. (See below regarding
recipient tables.)
The design of these tables have certain minimum requirements, particularly their
names and the names of the required fields therein.
[A future release may remove
this constraint in order to accommodate pre-existing databases.]
Table design
All tables consist of a set of congruent records (rows), each containing an identical
set of fields (columns). The tables retain their particular structure even when empty.