
                      HAMPTON ROADS CLIPPER USERS GROUP

                        DBEDIT() DEMONSTRATION PROGRAM

                                 June 9, 1990

by:  Robert Williams
     CompuServe:  73537,3431


INTRODUCTION

This program is a tutorial to demonstrate the DBEDIT() function of Nantucket 
Corporation's Clipper (Summer '87 Version).  DBEDIT is a powerful function for 
displaying and/or editing records from a dBASE III file.  It can be fine tuned 
through the use of a user defined function (UDF) to provide data validation, 
lookup tables, or perform other procedures and reports.

DATA FILES

This demonstration program uses three data files.  These files are created and 
filled by DBE_FILE.PRG.

DBE_DEMO.DBF is used by the program's main menu.

     Field  Field name   Type      Width  Dec
         1  FILENAME     Character    12     
         2  DESCRIP      Character    50     
         3  DEMOPROC     Character     8     

PEOPLE.DBF contains a few fields that are associated with each person.

     Field  Field name   Type      Width  Dec
         1  NAME         Character    20     
         2  RANK         Character     3     
         3  WPID         Character     4     
         4  LAST_EXAM    Date          8     

SHOP.DBF contains fields related to workplaces within an organization.

     Field  Field name   Type      Width  Dec
         1  UNIT         Character    20     
         2  SHOP         Character    20     
         3  EXAMCODE     Character     1     
         4  WPID         Character     4     


SHOPWPID.NTX is used by SHOP.DBF to index the file on the WPID field.

SCENARIO

PEOPLE.DBF and SHOP.DBF are two files used by EXAMPLE Air Force Base to help 
track periodic physical examinations associated with its occupational health 
program.  The workers are linked to their shop by the Workplace Identifier 
(WPID).

This demonstration will start with a straight call to DBEDIT() and progress 
through all of its optional parameters until we have demonstrated all of the 
parameters.

Please scan through the source code by selecting a demonstration from the Main 
Menu, then view the demonstration by pressing <F10>.



*<EOF:  DBEINTRO.TXT *---------------------------------------------------*



