Specifications

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