**** NOTICE **** Before you perform this installation, be aware that these programs will drop and recreate the following tables: InputPages InputLines InputDB InputAttributes So if you have a table in your SQL database with the same name as any of the above tables, this installation process will destroy YOUR tables and recreate them for use with DBIforms. Installation ------------ 1: Download the DBIforms.tar.Z file into the "/tmp" directory. 2: Uncompress the DBIforms.tar.Z file: uncompress DBIforms.tar.Z 3: Change directories into the "cgi-bin" directory of your web server 4: Extract the contents of the compressed tar file as follows: tar -xvf /tmp/DBIforms.tar 5: This will create a directory called "DBIforms" and will contain the following files: DS_DBIforms.pl select.pl insert.pl update.pl delete.pl mktables.pl mkinputpages.pl mkinputlines.pl associateinfo.pl 6: Edit the file "DS_DBIforms.pl" to point to a valid SQL data source. For additional instructions on this step, review the DBI documentation. 7: run the program "mkinputpages.pl" to create the DBIforms pages in the SQL database referred to in DS_DBIforms.pl. 8: run the program "mkinputlines.pl" to create the DBIforms input lines in the SQL database referred to in DS_DBIforms.pl. 9: run the program "associateinfo.pl" to create the example form. 10: From a web browser run the program "/cgi-bin/DBIforms/select.pl". 11: Select the form "AssociateInfo". You may now select, insert update and delete records into/from the SQL database. 12: To create a new form, from a web browser run the program "/cgi-bin/DBIforms/insert.pl". 13: Click on the link labeled "Click Here to insert new records for form MKPAGE". 14: Give your new form a unique "Form Name" and "Page Title". You may also change any of the look-and-feel values if you like. Then press the "Submit" button. 15: At the bottom of the new page, click on the link labeled "INSERT". 16: Click on the link labeled "Click Here to insert new records for form MKLINE". 17: Define an input line to be displayed on your form. 18: Define another input line to be displayed on your form. 19: Define a third input line to be displayed on your form. 12: Create the SQL tables defined by the form lines you created by running from a web browser, the program "/cgi-bin/DBIforms/mktables.pl". 18: Click on the link associated with the form you defined. If an SQL error occurs, go back and click the link again. The second click should show the table was created successfully. 19: To insert new records into your SQL database table, from a web browser run the program "/cgi-bin/DBIforms/insert.pl". Click on the link associated with the form you defined.