background image

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.

This Agreement does not authorize you to distribute the SOFTWARE.

COPYRIGHT. The SOFTWARE is owned by AMX Corporation, and is protected by United States copyright laws and 
international treaty provisions. Therefore, you must treat the SOFTWARE like any other copyrighted material (e.g., a 
book or musical recording) except that you may either (a) make one copy of the SOFTWARE solely for backup or archi-
val purposes, or (b) transfer the SOFTWARE to a single hard disk provided you keep the original solely for backup or 
archival purposes. You may not copy the written materials accompanying the SOFTWARE.

OTHER RESTRICTIONS. You may not rent or lease the SOFTWARE, but you may transfer the SOFTWARE and 
accompanying written materials on a permanent basis provided you retain no copies and the recipient agrees to the 
terms of this Agreement. You may not reverse engineer, decompile, or disassemble the SOFTWARE. If the SOFT-
WARE is an update or has been updated, any transfer must include the most recent update and all prior versions.

You may use only one version of the SOFTWARE at any time. You may not use the version of the SOFTWARE not 
being run on your CPU on any other CPU or loan, rent, lease or transfer them to another user whether with or without 
consideration.

LIMITED WARRANTY

LIMITED WARRANTY. AMX Corporation warrants that the SOFTWARE will perform substantially in accordance with 
the accompanying written materials for a period of ninety (90) days from the date of receipt. Any implied warranties on 
the SOFTWARE and hardware are limited to ninety (90) days and one (1) year, respectively. Some states/countries do 
not allow limitations on duration of an implied warranty, so the above limitation may not apply to you.

CUSTOMER REMEDIES. AMX Corporation’s entire liability and your exclusive remedy shall be, at AMX Corporation's 
option, either (a) return of the price paid, or (b) repair or replacement of the SOFTWARE that does not meet AMX Cor-
poration's Limited Warranty and which is returned to AMX Corporation. This Limited Warranty is void if failure of the 
SOFTWARE or hardware has resulted from accident, abuse, or misapplication. Any replacement SOFTWARE will be 
warranted for the remainder of the original warranty period or thirty (30) days, whichever is longer. 

NO OTHER WARRANTIES. AMX Corporation disclaims all other warranties, either expressed or implied, including, but 
not limited to implied warranties of merchantability and fitness for a particular purpose, with regard to the SOFTWARE, 
the accompanying written materials, and any accompanying hardware. This limited warranty gives you specific legal 
rights. You may have others which vary from state/country to state/country.

NO LIABILITY FOR CONSEQUENTIAL DAMAGES. In no event shall AMX Corporation be liable for any damages 
whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business 
information, or any other pecuniary loss) arising out of the use of or inability to use this AMX Corporation product, even 
if AMX Corporation has been advised of the possibility of such damages. Because some states/countries do not allow 
the exclusion or limitation of liability for consequential or incidental damages, the above limitation may not apply to you.

U.S. GOVERNMENT RESTRICTED RIGHTS

The SOFTWARE and documentation are provided with RESTRICTED RIGHTS. Use, duplication, or disclosure by the 
Government is subject to restrictions as set forth in subparagraph (c)(1)(ii) of The Rights in Technical Data and Com-
puter Software clause at DFARS 252.227-7013 or subparagraphs (c)(1) and (2) of the Commercial Computer Soft-
ware--Restricted Rights at 48 CFR 52.227-19, as applicable. Manufacturer is AMX Corporation, 3000 Research Drive, 
Richardson, TX  75082.

If you acquired this product in the United States, this Agreement is governed by the laws of the State of Texas.

Should you have any questions concerning this Agreement, or if you desire to contact AMX for any reason, please 
write: 

AMX Corporation, 3000 Research Drive, Richardson, TX  75082

.

Summary of Contents for DBWizard

Page 1: ...instruction manual integration Solutions i DatabasePlus and DBWizard...

Page 2: ...lity and your exclusive remedy shall be at AMX Corporation s option either a return of the price paid or b repair or replacement of the SOFTWARE that does not meet AMX Cor poration s Limited Warranty...

Page 3: ...ge SQL 5 HTTP CGI and XML 6 HTTP Hyper Text Transfer Protocol 6 CGI Common Gateway Interface 6 XML Extensible Markup Language 7 Creating an ASP file 9 Creating an AXI file 9 Creating an AXS file 15 Ne...

Page 4: ...i i Database Plus and DBWizard Table of Contents Webserver path 32 Absolute database path 32 NetLinx AXI file 32 NetLinx local IP port 32 NetLinx code prefix 32 Encapsulate 32 Writing Your AXS File 33...

Page 5: ...is an application that helps you generate NetLinx code to access a PC database The NetLinx Master can read and write to the database via a web server connection DBWizard helps generate the SQL and Ne...

Page 6: ...navigate to a directory other than the default install directory if desired Click Next 6 In the i Database Plus Shortcut Creation dialog select Install Shortcut Icons for the installed components on y...

Page 7: ...rnal Server Error message when trying to view ASP pages in a web browser the web server is not installed properly You must correct this problem before proceeding Once the server PC is setup make sure...

Page 8: ...Introduction 4 i Database Plus and DBWizard...

Page 9: ...connect to a database type not listed contact the vendor and obtain the ODBC drivers for that database 3 Connect to the database This will vary depending on the database you chose If you chose a Micro...

Page 10: ...CGI Common Gateway Interface CGI provides a simple way to pass parameters to a program from an HTTP request Most commonly the CGI parameters appear directly on the URL line For example http www someho...

Page 11: ...ata var var name TotalRecords name data 3 data var struct array struct index 1 index var name TitleID name data 11101000 data var array name Artist name string Buffet Jimmy string array array name Tit...

Page 12: ...llow Each record is wrapped in a struct struct pair and the columns of each record are represented by the var var pairs The index index pair represents the index into the array that this structure or...

Page 13: ...t s time to program the NetLinx AXI file You need to include NetlinxDBInclude axi in order to provide access to the support functions that make your job much easier In the process of writing the AXI f...

Page 14: ...QL and database setup information When building SQL statements you need to know the names of the tables and or view and usually the names of any columns you are interested in reading or writing Anothe...

Page 15: ...that SQL considers invalid like spaces and dashes If you are using column names with these characters or continually get SQL syntax errors try wrapping the column names in a pair of brackets This is S...

Page 16: ...trSQL UPDATE Titles SET Artist 27 strArtist 27 Copyright 27 strCopyright 27 Label 27 strLabel 27 ReleaseDate 27 strReleaseDate 27 Title 27 strTitle 27 TitleID ITOA slTitleID WHERE TitleID ITOA slTitle...

Page 17: ...NT The first thing to do is create a series of variables that needed through the event To kick off the processing call DB_PROCESS_HTTP_HEADER which will parse the HTTP header information from the resp...

Page 18: ...T TO THE WEB SERVER CLEAR_BUFFER sDB_CLIENT strBUFF SEND_STRING dvDB_CLIENT dB_BUILD_HTTP_GET sDB_CLIENT OFFLINE EVENT OFFLINE STACK_VAR LONG lCODE HTTP RETURN CODE INTEGER nLIST_PTR INDEX FOR RECORDS...

Page 19: ...TAL 0 sTempListBox snTOTAL TYPE_CAST nLIST_PTR DB_DISPLAY_TITLES sDB_TITLES sTempListBox CLEAR BUFFER DB_ACK_QUE sDB_QUE sDB_CLIENT CLEAR_BUFFER sDB_CLIENT strBUFF The very last bit of code keeps your...

Page 20: ...text The last bit of code uses information contained in your listbox 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...

Page 21: ...y 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 slid...

Page 22: ...rted to XML tag CDATAit Converts XML Parameter to CDATA format The CDATAit function is used when converting record sets to XML Syntax CDATAit strData Variables strData Represents the data to be wrappe...

Page 23: ...es RunDBQuery returns an XML representation of a record set ErrorToXML Converts error code and descriptions to XML The ErrorToXML function is used to convert errors to XML Syntax ErrorToXML nNumber st...

Page 24: ...0 bytes above the max URL size nDB_MAX_PARAM_SIZE 300 XML PARAMETER SIZE Maximum size of XML values and ASP cookie nDB_MAX_QUE_SIZE 10 WEB SERVER QUE SIZE Number of commands to allow in queue nDB_LIST...

Page 25: ...ER NQ_TAIL QUEUE TAIL POINTER CHAR bQ_HAS_ITEMS 1 IF ANY ITEMS ARE IN THE QUEUE CHAR bQ_READY 1 IF READY TO SEND THE NEXT CMD INTEGER NQ_MAX MAXIMUM ENTRIES IN QUE CHAR bINIT 1 IF INIT STRUCTURE _sDB_...

Page 26: ...Variables sDB_QUE Represents the sDB_QUE for a given database server script connection Required srHDR Required Represents a header to be added to the XML response to identify the response Required st...

Page 27: ...turn code Required Return Values DB_GET_HTTP_ERROR returns a string formatted for the error code in the format HTTP_ERROR error code error description DB_GET_HTTP_HEADERS Reads the HTTP headers from a...

Page 28: ...r script connection Required nPORT Represents the IP port of the web server for a given database server script connection If 0 is supplied 80 will be used Required strFILE Represents the Path and File...

Page 29: ...Variable sTempListBox Represents the list box structure Required nIDX Represents the new starting index for the list box Required bFROM_SLIDER Set to 1 if value is a raw 0 255 value from a slider Requ...

Page 30: ...Extracts the HTTP Headers Cookie value from an sDB_CLIENT structure The DB_PROCESS_HTTP_HEADER function is used to parse the response from the server DB_PROCESS_HTTP_HEADER looks for HTTP errors and...

Page 31: ...haracters illegal in URL s are replaced with a hex code equivalent The DB_STRING_REPLACE function is used to convert SQL queries into CGI strings Syntax DB_MAKE_URL_STRING CHAR strSTR Variable strSTR...

Page 32: ...t be able to access the database There is a problem in the setup If the file is not found the path is likely to be wrong If the script cannot connect to the database the MDB file is not located in the...

Page 33: ...absolute paths for the database APS and AXI files If you move the project you will be prompted to look for the database Use the provided dialog to browse to the database The normal File menu New Open...

Page 34: ...en query name is moved to the Queries box in the bottom right you are ready to build your next query You can enter multiple queries for any table or view in the database if you want to get different i...

Page 35: ...you are finished If this file exists you will be prompted to overwrite it Webserver host name or IP address The address of the web server that is running the ASP file The NetLinx code will require th...

Page 36: ...uded in your program If this file exists you will be prompted to overwrite it You should note that DBWizard will re generate the AXI file listed in the NetLinx AXI File text box Any changes you made i...

Page 37: ...ou you still have some work to do The AXI generated by DBWizard now contains all the code necessary to read and write information to the database as well as the basic infrastructure required to send y...

Page 38: ...e richardson TX 75082 USA 469 624 8000 800 222 0193 fax 469 624 7153 technical support 800 932 6993 033 004 2565 01 05 2005 AMX Corporation All rights reserved AMX the AMX logo the building icon the h...

Reviews: