Crestron
e-control Mail SW-MAIL
43
••
The e-Mail Database Tables
Installation & Reference Guide — Doc. 5798
The Queries table
The
Queries
table is used by scroller signal blocks to form queries which
provide access to the data in the other tables. Using the
Database | Queries Table…
command, you can view this table’s data. As supplied, the
Queries
table in the
sample database file is already set up for accessing the other tables. For more
information on the structure and use of the
Queries
table, refer to the SW-DBM
manual, Doc. 5823.
Tables for sending e-mail
The
e-Mail Tables
window (shown on the next page) provides access to all three
tables used by the e-mailer signal blocks for sending e-mail. However, in the figure,
which shows the contents of the supplied sample database file, you can see that a
number of records have already been added to each table. You may edit the fields
right in this window (see “Editing the Existing Database” on page 46).
All the fields visible in this window represent required fields which must not be
eliminated. Using other software, such as Microsoft
Access, you may insert
additional fields into the tables for your own purposes. Such fields will be accessible
in the
e-Mail Tables
window. Although not used by the e-mailer signal block, these
fields can appear indirectly, as columns in touchscreen “scrollers” bound to the
e-Mailer signal block.
One thing to note about these three tables is the one field they share in common. The
ID
field is used in all three tables a “primary key” for looking up data. As a primary
key, the value of this field must be unique for each record in a given table.
The “e-Mail Tables” window, showing contents of tables
from the supplied sample database file
The following subsections discuss the interesting features of each table shown above.
Note that all defined e-mailers will use the same three tables.
The
eMail_Msg
Table
Each record in the
eMail_Msg
table must contain at least the following fields:
ID
,
abbr
,
subj
,
body
, and
defaultAddr
. The
defaultAddr
field can either be blank or
may contain a reference to a single default recipient, represented by the ID number
of a record in the
eMail_Addr
table.
