.com Solutions Inc. - logo  
Products - Header Buttons
.
FmPro Migator bullet item 7b VFP Code Converter bullet item 7b FmPro Script Diff bullet item 7b SQLite Diff bullet item 7b Screenshot Toolbar bullet item 7b Printer Maintainer
.
.
.
. .

 

 

. .

 

...
.

Fmpro Migrator - Oracle Files Title

CGIScripter Demo Available for download...

CGIScripter creates 15 files (including Perl, HTML, and SQL code) for each form which has been defined within the CGIScripter application. This page provides descriptions of the generated output files, links to sample files created by CGIScripter and flowcharts for Perl CGI script processing. Click on the link to the example filename to see the output file generated by CGIScripter.

.

Filename Features
example_create_table1.sql This sql script creates the Oracle user, tablespace and table for the web application data.
Notes: The Oracle DBA should review and update the DDL code within this file prior to creating the tablespaces, table, sequence, and trigger. The sequence start value (if implemented) should have the starting number determined by the DBA. The Oracle VARCHAR2 column widths should be reduced to the maximum size actually used within the web application.
CLOB/BLOB datatype columns may be stored within locally managed tablespaces with Oracle 9.2.0. Otherwise, a dictionary managed tablespace should be used.
example_instructions.txt
This file contains the setup, usage and troubleshooting instructions for the Perl CGI scripts generated by CGIScripter.
example_submit1.html                   Submit Form Flowchart
This HTML submit page POSTs information to the example_submit1 CGI script.
example_submit1
This Perl program accepts web submitted form data, provides data validation and auto-enter processing, then writes the entered data into the database.
example_query1.html                     Query Form Flowchart
This HTML query page POSTs information to the example_query1 CGI script.
example_query1                                   Sample Query List
This Perl program processes web queries which are displayed as a list of query results retrieved from the database.
example_display_record1              Sample Display Record
This Perl program accepts the primary key value passed in the URL then retrieves and displays this one record from the database. If the cnum parameter is passed to this script in the URL, then this script simply passes the GIF or JPEG image data to the browser.
example_update1.html                  Update Form Flowchart
This HTML update page POSTs information to the example_update1 CGI script.
example_update1                                Sample Update List
This Perl program processes web queries which are displayed as a list of query results retrieved from the database.
example_update_record1             Sample Update Record
This Perl program accepts the primary key value passed in the URL then retrieves and displays this one record from the database with updatable fields. If the cnum parameter is passed to this script in the URL, then this script simply passes the GIF or JPEG image data to the browser.
example_update_record_validate1                   
This Perl program accepts web submitted form data from the update script, provides data validation then updates the specified record in the database.
example_delete1.html                    Delete Form Flowchart
This HTML update page POSTs information to the example_delete1 CGI script.
example_delete1                                   Sample Delete List
This Perl program processes web queries which are displayed as a list of query results retrieved from the database.
example_delete_record_display1     Sample Delete Record
This Perl program accepts the primary key value passed in the URL then retrieves and displays this one record from the database. If the cnum parameter is passed to this script in the URL, then this script simply passes the GIF or JPEG image data to the browser.
example_delete_one_record1
This Perl program accepts the primary key value passed in via an HTTP POST then deletes that one record from the database. For security reasons the primary key column name is hard coded into this script. Also, the referer URL must match the delete_record_display script - or the record will not be deleted.
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   

 

.

hline

. .

.

 

. .

 

 

 

Home | Products | Services | Downloads | Order | Support | Contact

Legal Notices

.
.   .
.
Home Products Services Downloads Order Support Contact