Specifications

Crestron e-control Mail SW-MAIL
45 •• The e-Mail Database Tables Installation & Reference Guide — Doc. 5798
Field Description
available) or the address (but not both) for each
recipient, separated by carriage-returns.
msgBody
Verbatim text of message.
msgNew
Indicates if message has been read yet or not. Used by
server to produce the new and old “mail views.”
msgDel
Indicates if the message has been marked for deletion
(i.e., the Delete signal was received following a Pick
n
signal that opened this message).
Message Display Table
Like the IN box table, the message display table is completely maintained by the
e-mailbox signal block. The structure of this table is simply a series of 80-character
lines with an ID field for proper ordering. The contents of this table are transient; it
emptied and repopulated every time the server opens a mail message.
Recipients Table
(Recipient tables are not used by the server at this time. A future server upgrade may
support a scroller for recipients as well. The table is included here so that today’s
database file will be compatible with tomorrow’s upgrade.)
Supplied Empty Tables
Creating new IN box and message tables is not possible from the server. To create a
new IN box table, use Microsoft® Access to copy one from the supplied sample
database file. (You only need to copy the structure of the table, not the data.)
As a courtesy to those users who do not have a copy of Microsoft® Access handy,
the supplied sample database file already contains five (5) sets of empty IN box and
message tables ready for use by up to five distinct e-mailbox signal blocks. Looking
at the Queries table (using the Database | Queries Table… command), you can
see five pairs of entries that refer to these five sets of tables. The essential
information is summarized below:
Query
Number
(ID)
IN box
table name
(Table)
Query
Number
(ID)
Message
table name
(Table)
10 Inbox1 11 msg1
12 Inbox2 13 msg2
14 Inbox3 15 msg3
16 Inbox4 17 msg4
18 Inbox5 19 msg5
The first set, queries 10 and 11, are used in Demo4.
Feel free to change the query numbers if you like (being sure to change them as well
in your scroller signal block definitions!), but without MS Access, you cannot
change the names of the tables to which they refer, so do not change the table names
in the Table field.