CREATING A TRAVEL EXPENSE DATABASE

 Now that your database program is running, you are ready to create a database file. Type the following entries at the dot prompt.

NOTE

If you are using Clipper, use the DBU. EXE program to create your database. Because Clipper does not have an interactive mode, it does not display a “dot” prompt and the creation process is different, However, you can create an identical database using the DBU utility.

1.         Create a database structure: CREATE EXPENSE <Enter>.

2.         Type the field names, field types, field widths, and decimal places as shown:

Field         Field Name                         Type                Width               Dec

            1              PURPOSE             Character              15

                2              DATE                     Date                       8

                3              DAY                       Character              3

                4              DES                        Character              15

                5              EMPL                    Numeric 8              2

                6              COMP                    Numeric 8              2

                7              COMMENTS       Character              20