User manual AMX I!-DATABASEPLUS AND DBWIZARD

[. . . ] instruction manual i!-DatabasePlus and DBWizard i n t e g ra t i o n !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. The SOFTWARE is owned by AMX Corporation, and is protected by United States copyright laws and international treaty provisions. [. . . ] There are two Send_Command's that send Artists and CD Title information to our touch panel. Continue looping up to the display size, which is the total number of items that can be displayed, and clear out the variable text. The first Send_Command displays record information in the form displaying 1 - 10 of 100. The listbox also has a value you can send to a slider to represent the current position in the list, like a scroll bar. 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. Call DB_LISTBOX_SET with a value of 1 to go to the beginning and a value of $FFFF to go to the end. 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. 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. 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. Syntax: CDATAit(strData) Variables: strData = Represents the data to be wrapped in CDATA. Syntax: GetXMLFromADORS(objADORS , strHdr, nStart, nPageSize) Variable: objADORS = Represents the record set object to be converted. [. . . ] If you have control of the web server, enter a simple directory name that represents your application. Then you can create this directory on your web server and place the database and database server script in this directory. 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. [. . . ]