Crestron
e-control Vote SW-VOTE
55
••
Database
Installation & Reference Guide — DOC. 5822
Field
Contents
Condition
The condition field should contain the following string, precisely, for agenda
scrollers:
not (number=NULL and name=NULL) and (closed=NULL)
This “filter” causes the query to include only non-empty, open items in the
resulting agenda item list. If you are not using the number field in your
agenda table, eliminate it from the above, as follows:
not (number=NULL) and (closed=NULL)
ListFields
The listFields field must contain the the field names number and name, as
shown.
DataFields
The dataFields field must contain the the field name description, as shown.
SQL
Null
Queue scroller tables
The request-to-speak queues are implemented as scrollers bound to tables with a
structure as shown in the table below. The “list fields” are
screenname
and
mark
which means that these are the fields which are displayed in each row of the scroller.
You can add additional fields such as “district,” “party,”
etc.
Structure of a queue scroller table, showing all required fields
Field Name
Data Type
Data Size
Indexed
ID
AutoNumber
Long Integer
Yes (No Duplicates)
Seat
Number
Integer
No
Screenname
Text
16
Yes (No Duplicates)
State
Text
1
No
Rank
Number
Byte
No
Field names are fixed and must appear exactly as shown above (case however is not
significant). Set
ID
to be the primary key. Any additional fields listed in the
listFields
field of the
Queries
table record that refers to this table must also be
included in the new table’s structure. These additional fields’ type and size must
match their sister fields in the
Members
table exactly. Do not index these
additional fields.
Rather than creating the tables from scratch, we recommend copying one from the
supplied sample database file. Then edit its structure to suit your needs and copy the
result for each queue, and for each “save file,” naming them as described above.
Agenda scroller tables
The agenda scroller “list field” is the
Description
field. When entering new agenda
items into such a table, fill in only the first four fields; the other fields should remain
blank.
Structure of an agenda scroller table, showing all required fields
Field Name
Data Type
Data Size
Indexed
ID
AutoNumber
Long Integer
Yes (No Duplicates)
Number
Text
16
Yes (Duplicates OK)
Name
Text
32
Yes (No Duplicates)
Description
Text
64
No
Opened
Date/Time
—
No
Closed
Date/Time
—
No
