
Crestron e-control Database Manager SW-DBM
41 •• Demos Installation & Reference Guide — DOC. 5823
If the scroller is an orphan (not owned), the scroller’s current pick action setting
determines what action to take. The default action (value = 0) is to “open” the record
and transmit its contents using the Data
d
signals. The order in which the fields are
sent is as listed in the dataFields field of the Queries table. Certain listed fields
may be omitted based on the current value of the data filter bit pattern.
NOTE: There is only one pick action defined for orphan scrollers in the present release.
The CloseRec signal “deselects” the picked record, blanking the dataFields, and
making the record unavailable for deletion with the DeleteRec signal or for editing
with the Write
d
signals (see next section for more on these two signals).
Adding a Record
The NewRec signal creates a new record (a blank row) in the current database table.
You can then update the fields in this new row as described in the section “Updating
a Record” (below).
Updating a Record
Fields may be changed repeatedly using the Write
d
signals which update records
immediately upon receipt by the server. The numbering of the Write
d
signals
parallels that of the Data
d
signals.
Upon a successful write, the server always echoes back the written data in a Data
d
signal which updates the data field on the touchscreen to match the data just written
out to the database file. Also, if the field so changed is also a list field (a field that
appears in the scroller itself), a List
r,c
signal may be sent as well. Finally, the Done
signal is pulsed after a successful write.
Deleting a Record
Once a record is picked, you can use a DeleteRec signal to delete it from the
recordset and the corresponding database table.
The DeleteAllRecs signal deletes all of the records in the table, leaving an empty
table. (Be very careful with this signal!)
Demos
Three demonstrations on the use of the Database Manager are included with the
package. Each demo is described along with an accompanying “bird’s eye view”
diagram of its SIMPL program. . All demos use the following three files:
• A VT Pro-e source file (demoDBM.vtp file), containing pages for all three
demos, ready to be compiled LC-3000 touchpanel.
• A compiled touchscreen file (demoDBM.hex file); dervied from the above;
ready to upload to an LC-3000, CT-3000, CT-3500, or VT-3500.
• A Configuration file (demoDBM.ini) configures the server for all three
demos.
In addition, each individual demo has a folder containing the following files:
• A SIMPL Windows source file (demo?.smw file), ready to be compiled for a
CNMSX-PRO control system (“PRO” = front panel with LCD display) with a
CNXENET (Ethernet) card in the DPA slot.
Kommentare zu diesen Handbüchern