User manual AMX I!-DATABASEPLUS AND DBWIZARD

[. . . ] instruction manual i!-DatabasePlus and DBWizard i n t e g ra t i o n !S o l u t i o n s Software Warranty Agreement GRANT OF LICENSE. AMX Corporation grants to you the right to use the enclosed i!-DatabasePlus and DBWizard software program (the SOFTWARE) on a single central processing unit (CPU). This license is for object code only and does not convey any rights to use of the source code. [. . . ] A template for this function is generated by DBWizard and included in the include file. The easiest way to write this function is to copy it from the . axi file and add any customizations required. (***********************************************************) (* SUBROUTINE DEFINITIONS GO BELOW *) (***********************************************************) (*********************************************) (* NAME: DB DISPLAY TITLES *) (***************************************************************************) (* Display a page of TITLES data *) (***************************************************************************) DEFINE_FUNCTION DB_DISPLAY_TITLES(_sDB_TITLES sDB_TITLES[], _sDB_LISTBOX sTempListBox) LOCAL_VAR INTEGER nLOOP { (* The following are elements of the structure where nLOOP=1 to nCOUNT: *) FOR (nLOOP = 1; nLOOP <= sTempListBox. nCOUNT; nLOOP++) { (* SEND_STRING 0, "'strArtist=', sDB_TITLES[nLOOP]. strArtist" SEND_STRING 0, "'strCopyright=', sDB_TITLES[nLOOP]. strCopyright" SEND_STRING 0, "'strLabel=', sDB_TITLES[nLOOP]. strLabel" SEND_STRING 0, "'strReleaseDate=', sDB_TITLES[nLOOP]. strReleaseDate" SEND_STRING 0, "'strTitle=', sDB_TITLES[nLOOP]. strTitle" SEND_STRING 0, "'slTitleID=', ITOA(sDB_TITLES[nLOOP]. slTitleID)"*) (* ADD DISPLAY CODE HERE *) SEND_COMMAND dvTP, "'!T', 0+nLOOP, sDB_TITLES[nLOOP]. strArtist" SEND_COMMAND dvTP, "'!T', 10+nLOOP, sDB_TITLES[nLOOP]. strTitle" Continued 16 i!-Database Plus and DBWizard Programming i!-Database Plus } FOR (; nLOOP <= sTempListBox. nDISPLAY_SIZE; nLOOP++) { (* CLEAN UP EMPTY ENTRIES HERE *) SEND_COMMAND dvTP, "'!T', 0+nLOOP, ''" SEND_COMMAND dvTP, "'!T', 10+nLOOP, ''" } SEND_COMMAND dvTP, "'!T', 49, 'Displaying ', ITOA(sTempListBox. snFIRST), '-', ITOA(sTempListBox. snLAST), ' of ', ITOA(sTempListBox. snTOTAL)" SEND_LEVEL dvTP, 1, sTempListBox. nLEVEL_VAL sTitleListBox = sTempListBox } The next section creates a level for the scroll bar. Use this later to actively jump to any point in your list. (***********************************************************) (* STARTUP CODE GOES BELOW *) (***********************************************************) DEFINE_START (* Get Level for active slider *) CREATE_LEVEL dvTP, 1, nTITLE_LVL The next section handles the request from the touch panel to manipulate your list. Use DB_LISTBOX_UP and DB_LISTBOX_DOWN to manipulate your list box. The next two buttons jump to the beginning and end of the list. Call DB_LISTBOX_SET with a value of 1 to go to the beginning and a value of $FFFF to go to the end. The value $FFFF is used here as a very large value. Anytime you try to set past the end of the list, DB_LISTBOX_SET will automatically make sure the selected value is inside the selected list. Using $FFFF is an easy way to force the function to automatically position to the end of the list. The last button is from your scroll bar slider. Notice you capture the position on the release after you have stopped moving the level and lifted your finger off the slider. Send the level you created earlier to DB_LISTBOX_SET and set the last parameter, bFROM_SLIDER, to 1. DB_LISTBOX_SET will automatically scale the value and select the position in the list that matches your request. After you have adjusted your listbox, call DB_READ_TITLES to build your SQL and send the request to the server. When the response from this request comes in, your DB_DISPLAY_TITLES function will be called and our requests will be displayed. A template for calling this function was generated by DBWizard and included in the include file. You can copy the call template from the include file and paste it into your code. (*******************************************) (* DEVCHAN: Title Control *) (*******************************************) BUTTON_EVENT[dcTITLES_CTRL] { PUSH: { STACK_VAR nIDX nIDX = GET_LAST(dcTITLES_CTRL) SWITCH (nIDX) { CASE 1: DB_LISTBOX_UP (sTitleListBox) CASE 2: DB_LISTBOX_DOWN (sTitleListBox) CASE 3: DB_LISTBOX_SET (sTitleListBox, 1, 0) CASE 4: DB_LISTBOX_SET (sTitleListBox, $FFFF, 0) } DB_READ_TITLES(sTitleListBox, "") Continued i!-Database Plus and DBWizard 17 Programming i!-Database Plus TO[dcTITLES_CTRL[nIDX]] } } If you want to edit the database, you need to capture data from the user and call your other SQL building routines to send your request off to the server. NetlinxDBInclude. asp Functions The following table describe the functions contained in the NetlinxDBInclude. asp file. NetlinxDBInclude. asp Functions XMLTag Converts field name to XML compatible tag. The XMLTag function is used when converting record sets to XML. Syntax: XMLTag(szStr) Variable: szStr = Represents the string to be converted to XML tag. (Required. ) Return Values: XMLTag returns the string converted to XML tag. CDATAit Converts XML Parameter to CDATA format. [. . . ] As you enter this value, a sample browser line will be built for you in the "Example Browser Path" window. You can use this example browser path to test you web server setup, as described in the Putting It All Together section on page 28. Absolute database path This will include the full path to the database in the database server script (ASP file). If you are running DBWizard on the server machine, you can check this box and you will not need to move the database. [. . . ]