Crestron e-control Database Manager, User Manual

Page 1: ...CRESTRON e control Database Manager SW DBM version 1 4 1999 Crestron Electronics Inc ...

Page 2: ...fying a Configuration File 16 Password Access 17 COM Settings Definition 18 Signal Block Definition 20 Server Windows and Menus 27 The Database File 32 Database Fundamentals 32 The Queries Table 35 Successive Queries 38 Operating on Database Tables 40 Demos 41 Demo 1 Database Browsing and Maintenance 42 Demo 2 Successive Query 43 Demo 3 AutoPick 45 Appendix A Theory of Operation 48 Server Protocol...

Page 3: ...ouchscreen LC 3000 CT 3000 CT 3500 or VT 3500 and A null modem cable Follow the instructions in the guides precisely in the order given and you should be up and running in a matter of minutes NOTE The demos included with this package are all compiled to two versions a COM version for use with an RS 232 serial connection and a TCP version for use with an Ethernet connection the latter case requirin...

Page 4: ...ce Guide DOC 5823 Detailed setup and configuration instructions and follow Introduction Then comes information about the database file format After that the examples demos are described and illustrated in detail Appendices include Theory of Operation along with a complete Signal Reference ...

Page 5: ...l modem cable Make sure pins 4 5 and 6 are not connected Connect a null modem cable from COM1 on the PC to COM A on the CNMSX PRO 5 Run the server The installer sets the server to use config file demoDBM ini Select shortcut e control Database Manager Server from the Crestron folder in the Windows Start Menu If the title bar of the window does not read e control Database Manager Demos use the File ...

Page 6: ...e latter type of connection the control system relies on an intermediary the Crestron CNX Gateway to translate communications protocols To aid in making all this clear the following illustrated discussion of system terminology and topology should prove useful at this point System Terminology and Topology This manual simultaneously discusses several different inter connected computer systems To red...

Page 7: ...n control system VT 3500 VT 3500 VT 3500 Database NOTE The CNX Gateway is not necessary when using RS 232 serial communications TCP IP connections between the server and the control systems require that each side of the connection be provided with the IP address of the other This kind of connection also requires the use of the CNX Gateway which is separately licensed software that facilitates comm...

Page 8: ...rocessor A faster processor is recommended for serving multiple connections simultaneously 800 x 600 or higher screen resolution COM ports Required to make serial RS 232 connections to control systems one port per control system See Cable requirements below Network Interface Card Required to make TCP IP connections to control systems TCP IP sockets These are software constructs provided by your op...

Page 9: ...ay is required This is actually only true for TCP IP connections Direct RS 232 connections do not require the CNX Gateway Licensing A 15 day free trial follows initial installation If you are still within the 15 day period you have the option to postpone licensing and skip to the next section Both the Software Server and the CNX Gateway are a licensed products which means that although both softwa...

Page 10: ...he box next to SW DBM It is permissible to exit the program while waiting for a Site Key to be issued The application can be restarted and the Site Key entered at a later time The Site Key issued is only valid on the same computer It does not work on a different computer The License Window of the CNX Gateway is almost identical to the above See the documentation that comes with the Gateway package...

Page 11: ...n the diskette or network drive and not on the computer If this file should become lost or damaged the license is lost as well Because of this please use the utmost care while performing this transfer Step 3 Bring the diskette back to the destination computer Click on the Transfer License button The computer reads the license information off the diskette and transfers the license to itself The ser...

Page 12: ...r RS 232 or TCP IP connections Actually a mixture of connections is permitted For example two control system might be connected via RS 232 using the COM1 and COM2 ports while two more might be simultaneously connected via the TCP IP network connection In the following the indented italicized paragraphs contain advice on setting up the server and a control system specifically to run the supplied de...

Page 13: ... upload the HEX file as is If you are working with another panel convert the file to your target panel and recompile 4 Connect to server Connect null modem cables Crestron model CNSP 532 from each control system to the server Each connection requires its on COM port on the server side The port to use on the control system depends on the specific model CNMSX PRO Use one of the built in COM ports Th...

Page 14: ...screen project files to the control system via a serial cable between any available COM port of the server and the COMPUTER port of the CNX control system This need not be the same machine that will run the Software Server Refer to the CNMSX manual latest revision of Doc 8118 for instructions This connection can be removed once the control system is programmed Open the Viewport and issue the Setup...

Page 15: ...ort A In the Configuration Manager drag drop a CNRACKX system onto the CNMSX PRO The converted system has a CNXCOM 2 card in slot 4 use Port A The converted system does not have a front panel so compile notices appear which can be ignored 10 Install touchpanel pages Upload the compiled VT Pro project file hex file to each control system As supplied the demo touchpanel file demomail vtp which conta...

Page 16: ...this signal block will communicate you can leave this blank for the now However the signal block cannot be activated until it references a COM Settings definition See COM Settings page 23 for a description of how to point a signal block to a COM Settings definition All the signal blocks in the demo configuration already point to a COM Settings definition Server Configuration In Depth This section ...

Page 17: ...guration Options window The Configuration options window General tab showing all tabs correct password entered Level 1 and 2 passwords may be changed from the General tab Click on the Change Password button to open the Change Password window Enter the old password and the new password twice Click OK to complete the change Resetting the Configuration Password In the event the password is misplaced ...

Page 18: ... active signal blocks Signal Blocks tab must reference such a structure See COM Settings page 23 for instructions on defining such a reference for your signal blocks The COM Settings tab The COM Settings tab of the Configuration Options window contains a list of data structures called COM settings definitions which represent connections to control systems From this tab you can activate and deactiv...

Page 19: ... in the demo configuration selected COM Settings definitions connections can be active or inactive A check in the box next to the definition name indicates that the connection is activated If not activated it is ignored when the server protocol is started The COM Settings window The COM Settings window for the connection defined in the configuration for demo 1 showing RS 232 communications selecte...

Page 20: ...tions mode In this frame you choose RS 232 or TCP IP connections The details are described in the Server Side configuration sections for RS 232 page 13 and TCP IP page 14 System level signal definitions In this window you can also define optional system level signals by checking the appropriate boxes Doing so defines a special signal block which communicates with its own Intersystem Communications...

Page 21: ...x and a message When attached to a controlling signal block a scroller is enabled automatically when the controller is enabled With an SW DBM license a Standard Scroller can be enabled directly and so can be used on its own whenever the full functionality of a Custom Scroller is not called for Standard Scroller signal blocks are simpler involving far fewer signals and options Their signal configur...

Page 22: ...the signal block name indicates that the signal block is activated If a signal block definition is not checked it is ignored when the server protocol is started neither accepting nor responding to incoming signals in its range Inactive signal blocks are not considered for signal space conflicts with other signal blocks when the server protocol is started NOTE Signal Blocks may be defined before or...

Page 23: ...l blocks require the following basic information Fields for these data are shown across the top of all Signal Block Definition windows Name A unique signal block name is required here This name is used in the server s user interface to identify the signal block It is also sent along with error messages to the control system to identify the source of the error We recommend choosing a name that refl...

Page 24: ... the DBMScroller SIMPL macro Due to the static definition the supplied macro can be used in your SIMPL programming Useful for browsing a database table and selecting a record therein Cannot display the records however Scroller display is limited to 8 rows x 2 columns maximum Does not require an SW DBM license If licensed for any other component that can make use of interactive database table displ...

Page 25: ...l above these options select between a line mode scrollbar and a bar mode scrollbar Demos 1 and 3 use a line mode scrollbar Demo 2 has a bar mode scrollbar You can also invert the direction of the scrollbar by checking the Invert direction box Blank Scroller Upon This group of specify when the server will blank the scroller As you can see from the figure a Standard Scroller can be blanked when the...

Page 26: ...ve Queries page 38 for complete information List Rows and List Columns Defined Sets the number of rows r and columns c defined for the scroller signal block These are reflected in the number of Listr c and Pickr signals That is there are r x c List signals and r Pick signals Local Feedback Check this option to define the three error signals ErrString ErrNumber and ErrTrigger in the signal block Th...

Page 27: ...he entry for the Writed signal in the Signal Reference for more information Buffer Checking the Buffer box enables the UpdateRec signal that copies changed scroller records to the database In the current version of the server this signal is not implemented the Write signals currently update the database Server Windows and Menus This section contains descriptions of the server s two main windows th...

Page 28: ...stored in the Windows registry and becomes the default configuration Use this command to select the appropriate configuration file for each demo before running it The following command is always available Exit terminates the server application If the server protocol is running a warning message appears The Server Menu Before the server protocol is started the following commands are available Serve...

Page 29: ...cally applied to the option the next time the window is opened Server Log Clear clears the message log The Database Menu This menu contains a single command Database Queries Table which opens the Queries Table window This window provides display and edit access to this essential table in the database file named in Configuration Options window See Editing the Table on page 38 for more information T...

Page 30: ...an analog signal to a string when that signal is received with a signal number that expects a serial signal To simulate a signal after selecting your signal block select an item from one of the signal lists You are now ready to send the signal To do so give the Simulate Incoming or Simulate Outgoing command see below The value frames Values for simulated signals are entered here See Incoming and O...

Page 31: ...gnal by entering data into one of the three value frames The frame to use is based on the signal selected Note that simulating an outgoing signal when the system associated with the signal block is not connected has no practical effect This function is also available by clicking the tx button under the incoming signal list The Log Menu This menu contains the following commands that affect the Sign...

Page 32: ...options are Forward from top which searches the entire log Backward to top which searches beginning with the signal on the highlighted line and continuing back to the beginning of the log and Forward to end then wrap around from top which also searches the entire log starting with the signal on the highlighted line The Database File Database Fundamentals For the reader unfamiliar with database con...

Page 33: ...read the names of the columns to retrieve and if you do not want to retrieve every row of a table it specifies a logical test for determining which rows to retrieve For example consider the Addresses table shown above which contains names addresses and phone numbers for Crestron offices Assume that you want to display the names and address columns for all offices in the USA In SQL the query would ...

Page 34: ...have in common that ties the information from the superior table to each and every record in the subordinate table In this case the pivot field is the Album ID This join creates a recordset with a record for each track that contains additional columns for selected fields from the Albums table In the following figure the album title appears in each track record A portion of the results of a join qu...

Page 35: ...tring and transmitted to the control system via the QueryDescription signal If the caption is not defined here the field name is used instead Square brackets are used around any table names field names and captions that contain spaces or punctuation Outer joins are also supported A LEFT JOIN includes all rows from the first table in the output even if it has no matching rows in the second table A ...

Page 36: ... of a QueryNumber signal During a successive query the dollar sign character embedded in the description string has special meaning See Displaying a Successive Query page 39 for more information Table The table column names the table or tables to be used in the query in this example it is the Addresses table This column is used to construct the FROM clause of the SQL request Any valid FROM clause ...

Page 37: ... concatenation which creates one text string by concatenating two individual strings ListFields The listFields column identifies the columns that comprise the scroller contents It is used to construct the SELECT clause of the SQL request There number of fields listed must be equal to or greater than the number of columns the scroller is currently using Successive queries require additional sets of...

Page 38: ... by selecting a cell or an entire row by clicking in the row margin and depressing the ESC key Additional records can be entered by scrolling down to the row containing an asterisk in the left most column and typing the information Use ENTER to advance to the next cell in a row The arrow keys also navigate between cells in a rows and between rows as well Use the Requery to show remote edits button...

Page 39: ...en a regular non DISTINCT query all 100 records would have appeared The fields used to display each level are listed on separate lines in the list fields column of the Queries table Each line may contain a single field as would be the case in the example above or a list of fields separated by commas for a multi column list display Queries table showing the query used for demo2 Demo 2 Successive Qu...

Page 40: ...plays the preceding level s list the latter jumps directly to any preceding level Attempts to jump ahead are ignored Special Considerations Since a single scroller structure is utilized for each level in a successive query the multi page display paradigm suffers from a lack of buffering That is on each succeeding page the old data is still visible upon arrival This is serious eyesore when the colu...

Page 41: ...cessful write the server always echoes back the written data in a Datad 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 Listr c signal may be sent as well Finally the Done signal is pulsed after a successful write Deleting a Record Once a re...

Page 42: ...rd that lets you enter new information for that field Clicking OK on the keyboard when finished typing closes the keyboard enters the text the user typed in the datafield on the touchscreen and sends a WriteField signal to the server that updates the database record In a future release the table will not be updated until the server receives an UpdateRec signal Selecting the Add a new record button...

Page 43: ... implement successive queries check the successive query checkbox in the Signal Block Definition window and indicate the number of levels needed for the query At the start of this demo the scroller displays a list of music categories from the Albums table using a GoLevelEcho1 signal indicating that this is the top level of the successive query The user drills down from these broad categories to fi...

Page 44: ...39 text40 text48 an_fb1 First fb Prev fb Next fb Last fb GoLevel1 fb GoLevel2 fb GoLevel3 fb GoLevel4 fb Pick1 fb Pick2 fb Pick3 fb Pick4 fb Pick5 fb Pick6 fb Pick7 fb Pick8 fb WaitMsg GoLevel1 echo GoLevel5 echo List1 1 List1 8 QueryDescription Data1 List2 1 List2 8 Data2 List3 1 List3 8 Data3 List4 1 List4 8 ErrString Data4 Data12 Scrollbar Touchpanel Done First Prev Next Last Pick1 Pick2 Pick3 ...

Page 45: ...o has areas for reselecting each type of entity from each level of the query Touching one of these areas invokes the appropriate GoLevel signal which displays the appropriate page Note that there are no page flips in this demo because the query level always sends a specific group of listFields to the touchscreen and this determines the page displayed Demo 3 AutoPick This demo illustrates the use o...

Page 46: ...32 the virtual COM port is simply replaced with a real serial COM port Demo 3 SIMPL Windows Program Two items need to be added to the control system in the Configuration Manager in SIMPL Windows From the Control Systems folder in the Device Library select CNMSX AV and also add a two way serial driver to a COM port on the CNXCOM 6 board from the Serial Drivers General folder or add a Virtual Commun...

Page 47: ...estron e control Database Manager SW DBM 47 Demos Installation Reference Guide DOC 5823 On page 3 the album cover is again displayed with the message Now playing Touch the album image to return to page 2 ...

Page 48: ...f each type cannot exceed the respective limits of your license Should this happen a warning appears on the Signal Blocks tab and the server protocol does not start There is no theoretical limit to the total number of signal blocks which may be defined in a given configuration A practical limit has yet to be determined Signal Block Enable Disable Whereas most digital signals are pulsed the Enable ...

Page 49: ...9 Appendices Installation Reference Guide DOC 5823 COM Settings definition which contains a similar set of error reporting signals These signals include ErrNumber ErrString and ErrTrigger See the Signal Reference beginning on page 58 for details ...

Page 50: ...on constrains the definition to ensure compatibility with this symbol Likewise Standard Scroller signal blocks can use the DBMScroller SIMPL Windows macro Each active signal block exchanges data with a particular running in a control system connected to the server Typically several signal blocks communicate with the same control system using several Intersystem Communications symbols This section ...

Page 51: ...4096 signals available However while the first 1024 signals may be of any type Analog serial or digital the remaining 3072 signals can only be used for digital signals An additional constraint imposed by the SIMPL Windows compiler is that each symbol and therefore each signal block on the server side must list all its digital signals after all its analog serial signals which may be intermixed Sinc...

Page 52: ...onal Intersystem Communications symbols using the same connection must specify a value to offset their signal numbers by a constant amount The top signals in such an Intersystem Communications symbol do not begin with zero but rather with the supplied offset This offset must be specified on both sides of the connection as follows On the server side the offset is entered into the textbox in the upp...

Page 53: ...e single channel connections Do not use multiple channels if there is any possibility of needing to revert to an RS 232 connection Multiple Connections Usually all Intersystem Communications symbols from a single control system talk to the server through one physical connection although it is possible to install multiple connections such as any combination of RS 232 connections each with its own c...

Page 54: ...a standard scroller signal block System A Crestron control processor along with appropriate programming String Proxies The various Echo signals keep a server side proxy of the data last sent to the system Before sending the new value is compared with the proxy and is only actually sent if it differs The proxy is then updated to match the new value In this way identical string data are not continua...

Page 55: ...hundred sixty nine 469 in base 10 again we are only interested in bit patterns here not the quantities they may represent Error Reporting At this time error handling is a little haphazard with some errors being tallied back to the control system while others are logged in the Server Monitor window Tallied Errors A descriptive string is sent with all errors via ErrString However while some are acco...

Page 56: ...Trigger server to system D COM Settings PingSvr system to server D COM Settings PingSys server to system D COM Settings PongSvr server to system D COM Settings PongSys system to server D COM Settings RefreshAll server to system D Scroller Signal Block Summary Some signals shown below cannot be defined in an e mailer scroller a restricted version of a standard scroller Signal Block Signal Name Dire...

Page 57: ... to server D Custom Scroller Requery system to server D Opening a record The following scroller signals open a record for display and marks it for editing Signal Block Signal Name Direction Type All Scrollers First system to server D All Scrollers Last system to server D All Scrollers Next system to server D All Scrollers Pickr system to server D All Scrollers Prev system to server D Note that the...

Page 58: ...ignal Block Signal Name Direction Type Custom Scroller Blank and BlankAll system to server D All Scrollers Enable system to server D All Scrollers First system to server D Custom Scroller GoLevelv system to server D All Scrollers Last system to server D All Scrollers Next system to server D All Scrollers Prev system to server D Custom Scroller Refresh and RefreshAll system to server D Custom Scrol...

Page 59: ...ital Value Pulse Expected Reply Possible List signals all with null strings followed by pulse of Done signal Comments The server sends a null string to each column in each row using List signals List fields which are already null are not updated See String Proxies page 54 Automatically effected when scroller signal block is disabled This signal cannot be defined in an emailer scroller See Also Lis...

Page 60: ... with null strings followed by pulse of Done signal Comments The server responds as if a Blank signal had been received from each scroller defined for the system from which the signal was received That is the server sends a null string to each column in each row of each list using List signals Note however that all scrollers are blanked regardless of whether or not they are enabled at the time the...

Page 61: ... signal is only effective when a record is opened This would normally be the most recent record picked If no record has yet been picked since the query was initiated or the scroller has been scrolled or the CloseRec signal has been pulsed pulsing ClearRec produces the following error You must choose a record first If successful the data fields are all blanked As usual fields already blanked are no...

Page 62: ...t all data fields are blanked and signals that operate on opened records including this one is henceforth ineffectual This signal is only effective when a record is opened This would normally be the most recent record picked If no record has yet been picked or the scroller has been scrolled or this signal has already been pulsed pulsing CloseRec again produces the following error You must choose a...

Page 63: ...olumns displayed in the scroller Direction System to Server Type Analog Value 1 through the number of columns defined Expected Reply Possible List signals all with null strings pulse of the Done signal Comments If the new number of columns is less than the old number the extra columns are blanked Not implemented in the present release See Also ...

Page 64: ...ed in the Scroller Signal Block Definition window all the list fields listed in the listfields field of the Queries table are echoed using the first so many Data signals Only the last list in the successive query is actually considered to be a pick record opener When the record is finally picked the fields listed in the datafields field of the Queries table are transmitted using the remaining Data...

Page 65: ...ls Data2 and Data4 All Data signals in a successive query are subject to filtering including those signals used to echo the list fields Example 2 Consider Example 2 in the entry for the Data signal To filter out extra list field columns from being echoed as well as any echoes from the last list at all and to echo only the second field listed in datafields set the filter to 83 With this setting onl...

Page 66: ...ngerous signal Qualifying records means records that qualified for inclusion in the query that created the recordset Referenced table s means the table s referenced by the recordset associated with the scroller signal block All such records are deleted More than one table could be referenced if the table field of the Queries table contains a join See See Joins Accessing Multiple Tables on page 33 ...

Page 67: ...ordset and hence from the table or tables upon which the recordset is based The data fields are all blanked The record is removed from the scroller This signal is only effective when a record is opened This would normally be the most recent record picked If no record has yet been picked or the scroller has been scrolled or the CloseRec signal has been pulsed pulsing DeleteRec produces the followin...

Page 68: ...tion Indicates requested operation complete Direction Server to System Type Digital Value Pulse Expected Reply None Comments Sent to System in response to most System to Server signals indicating that the requested operation has been completed Typically there is a 0 2 sec delay between the leading and trailing edge of the pulse See Also ...

Page 69: ...al block remains disabled To try again it is first necessary to de assert the Enable signal in order to re assert it To try again with a different query number before re asserting set the query number using the NewQuery signal Upon successful enable the following takes place The scroller is blanked but only if the Blank scroller upon signal block enable checkbox in the Scroller Signal Block Defini...

Page 70: ...signal block usually upon arrival to a certain touchscreen page the System should 1 Wait for assertion of Enabled before issuing any other scroller signals 2 Indicate an error condition if assertion of Enabled does not occur after a certain amount of time typically 30 seconds When disabling the signal block usually upon arrival to a certain touchscreen page the System should 3 Wait for de assertio...

Page 71: ...ly None Comments This signal works in conjunction with the ErrString and ErrTrigger signals which always follow immediately For an e mail scroller this and the other Err signals are always defined For a standard scroller they are optionally defined in the Standard Scroller Definition window Local Errors checkbox When not defined the server attempts to use the SYSTEM error signals unless they too a...

Page 72: ...the server in two ways 1 Used in conjunction with the ErrNumber and ErrTrigger signals the latter following immediately 2 Used alone for informational messages Sometimes these messages represent error conditions and sometimes they are purely informational For an e mail scroller this and the other Err signals are always defined For a standard scroller they are optionally defined in the Standard Scr...

Page 73: ... the ErrNumber and ErrString to indicate that an error condition has occurred For an e mail scroller this and the other Err signals are always defined For a standard scroller they are optionally defined in the Standard Scroller Definition window Local Errors checkbox When not defined the server attempts to use the SYSTEM error signals unless they too are not defined This signal can be safely ignor...

Page 74: ... First scroller signal Description Displays the scroller s first page Direction System to Server Type Digital Value Pulse Expected Reply List signals ScrollBar signal pulse of Done signal Comments Automatically effected when scroller signal block is enabled See Also Enable Prev Next Last signals ...

Page 75: ...onfiguration options GoLevelEcho signal pulse Scroller refresh with new data Done signal pulse Comments The number of GoLevel signals v is the number of successive query levels defined in the Configuration Options window The purpose of the GoLevel signals is to return to a preceding level These signals cannot be used for forward navigation Example From level 2 GoLevel1 and GoLevel2 are valid but G...

Page 76: ...ver responds with this signal upon receipt of the following signals q Enable enabling the scroller q Pick a valid scroller pick q GoLevel explicit backward navigation q UpLevel explicit backward navigation Note that the number of GoLevelEcho signals v 1 is always one more than the number of GoLevel signals v the number of successive query levels defined in the Configuration Options window The reas...

Page 77: ...iption Displays the scroller s last page Direction System to Server Type Digital Value Pulse Expected Reply List signals ScrollBar signal pulse of Done signal Comments There may be empty rows at the bottom of the last page Picking one of these produces the error Pickn error No such record See Also First Prev Next signals ...

Page 78: ...t signal transmits the contents of one indirect text field representing a cell each column within each row in the scroller Expected Reply None Comments Not all List signals are always sent see String Proxies page 54 See Also The following signals each have the potential to alter the scroller contents Enable NewQuery First Prev Last Next Blank BlankAll Refresh RefreshAll Requery RequeryAll DeleteRe...

Page 79: ...enced if the table field of the Queries table contains a join See Joins Accessing Multiple Tables on page 33 for more information on the joins The new record is represented at the end of the scroller signal block s recordset and hence at the end of the last page of the scroller display It only appears in its proper sorted position when the scroller is disabled re enabled or the Requery signal is p...

Page 80: ...ence Guide DOC 5823 Next scroller signal Description Displays next scroller page Direction System to Server Type Digital Value Pulse Expected Reply List signals ScrollBar signal pulse of Done signal Comments No effect if currently on last page See Also First Prev Last signals ...

Page 81: ... When the user touches a row in the scroller the corresponding Pick signal is sent to the server The server knows what scroll page the user is seeing and opens the indicated record How the server responds to the Pick signal is determined first by whether the scroller is owned by any other signal blocks If so the signal block s code responds to the touch in its own way Second if the scroller is gen...

Page 82: ...y opened the way TCP IP connections are Assuming a reliable connection has been established a secondary reason to ping the Server using either communications mode is to test the communications protocol and Server operation in general For the Server to PingSys the Systems and get a PongSys in response also requires one of the PingPong programs to be loaded into the control systems If you wish to ke...

Page 83: ...ce Guide DOC 5823 Prev scroller signal Description Displays previous scroller page Direction System to Server Type Digital Value Pulse Expected Reply List signals ScrollBar signal pulse of Done signal Comments No effect if currently on first page See Also Prev Next Last signals ...

Page 84: ...d Expected Reply None Comments Sent when query is made either when the signal block is enabled by the Enable signal or after enable upon initiation of a new query by the NewQuery signal Typically displayed on touchscreen above scroller In a successive query the name of the first field in each query is sent upon arriving at each level This value has a proxy and hence is only sent when it changes Se...

Page 85: ...which causes server to respond Direction System to Server Type Digital Value Pulse Expected Reply List Data and QueryDescription serial signals Comments Normally used to re establish the contents of all scroller related indirect text fields See String Proxies page 54 This signal cannot be defined in an emailer scroller See Also List Data and QueryDescription signals ...

Page 86: ...followed by all in use List signals Comments Despite its name this signal does not actually re run the query it just moves through the already established recordset again to rebuild the current scroller page sending serial data back to the control system via the List signals Note that all these list signals are always transmitted because the proxies are also being rebuilt If a record is opened whe...

Page 87: ...Database Manager SW DBM 87 Appendices Installation Reference Guide DOC 5823 Requery All system signal Description Direction Type Value Expected Reply Comments Not implemented in the present release See Also Enable signal ...

Page 88: ...r of rows displayed in the scroller Direction System to Server Type Analog Value 1 through the number of rows defined Expected Reply Possible List signals all with null strings pulse of the Done signal Comments If the new number of rows is less than the old number the extra rows are blanked Not implemented in the present release See Also ...

Page 89: ... the gauge is filled value 2 3 x 65535 43690 and on the third page the entire gauge is filled value 3 3 x 65535 65535 Line Mode shows progressed based on the first row on the first page through the last row on the last page The formula the server uses to calculate the value is p 1 pps 1 x 65535 Example 2 Again there are three pages On the first page the gauge is empty value 1 1 3 1 x 65535 0 on th...

Page 90: ... database file with field edits Direction System to Server Type Digital Value Pulse Expected Reply Done signal Comments Any changes made to any field s in the opened record including possibly a new record made with the WriteField signals are output when the UpdateRec signal is pulsed Not implemented in the present version See Also WriteField signal ...

Page 91: ...ccessive query Direction System to Server Type Digital Value Pulse Expected Reply Scroller blanking as per configuration options GoLevelEcho signal pulse Scroller refresh with new data Done signal pulse Comments Ignored if received when on the top level level 1 However valid when received after data display final scroller pick See Also GoLevel GoLevelEcho Done signals ...

Page 92: ... a successful write the server always echoes back the write data in a Data signal which updates the data field on the touchscreen to match the data just written out to the database file Also if the field change is a field which appears in the scroller itself a List signal may be sent as well Finally the Done signal is pulsed after a successful write The numbering of the WriteField signals parallel...

Page 93: ...Crestron e control Database Manager SW DBM 93 Appendices Installation Reference Guide DOC 5823 ...

Page 94: ...Crestron e control Database Manager SW DBM 94 Appendices Installation Reference Guide DOC 5823 ...