Dynamic Web File Maintenance

1
Dynamic Web File Maintenance

• Reasons for development
• Design Objectives
• Development methods
• Code examples
• Demo

2
Dynamic Web File Maintenance

• Reasons for Development
• Create a highly flexible web based environment
• Speed future development efforts
• Simplify file maintenance tasks

3
Dynamic Web File Maintenance

• Design Objectives
• Initially Web based but expand the methods to
  other UI later
• Single code source for all reference data
  manipulation
• Use Progress dynamic capabilities to create a
  single code set for all maintenance routines

4
Dynamic Web File Maintenance

• Objectives (contd)
• Highly customizable through the use of Super
  Procedures
• Build on already proven methods for dynamic data
  manipulation/display (DataPump etc.)

5
Dynamic Web File Maintenance

• Methods
• Use proper tiering of application layers
• All data access is dynamically generated
• Start at lowest level of functionality and build
  up from there (bottom up approach)

6
Dynamic Web File Maintenance

• Methods (contd)
• Dynamically generate web pages based on specific
  structure in the record
• Develop a single set of routines that will work
  for all database tables
• Super procedures for display of

7
Dynamic Web File Maintenance

• Methods (contd)
• DataPump Super procedures for data display to
  allow for over ride as necessary
• All data queries use Progress dynamic query
  structure

8
Dynamic Web File Maintenance

• Methods (contd)
• Data table and key field information are passed
  in the web query stream
• All requests are via Post methods to the web
  server.
• Data Acceptor routine collects all data and
  determines what routines to run

9
Dynamic Web File Maintenance

• Data Acceptor Sample Code
• create buffer hfieldbuf for table filnm.
• case i-mode
• when "dodelete" then
• do
• run deleterec.p(input filnm,
• input keyfld " " reqnum) no-error.
• end. / when "dodelete" /

10
Dynamic Web File Maintenance

• Data Acceptor Sample Code
• when "goadd" then
• do
• run dispaddupd(input "add",
• input filnm,
• input keyfld,
• input "",
• input hfieldbuf,
• input prevcnt,
• input nextcnt).
• return. / return prevents run of display
  list /
• end. / when goadd /

11
Dynamic Web File Maintenance

• Run of display
• run baserun.p(input filnm,
• input keyfld,
• input wherecl,
• input i-mode,
• input nextcnt,
• input prevcnt,
• input maxreturn,
• input returncnt) no-error.

12
Dynamic Web File Maintenance

• Future Directions
• Modifications to allow Web Client/GUI display
• Enhance hooks for business logic insertion