How to change what fields are in a database

(Back to Index)

If you have created a database with EX3P, you may want to change the fields that are in it.

The basic procedure to change the fields is to:

  1. Go into EX3P
  2. Select ISTRUCTURE
  3. Change the fields list to what you want by using the following keys:
        ALT-C to clear all marked items (if you need to)
        ENTER to mark an item (or unmark one that is marked)
        ALT-X when you are done
    Answer "Y" to rewrite the .def file
  4. Select BACKUP to backup the database
  5. Select ERASE to erase the database
  6. Select RESTORE to read the data back in using the new structure

Here is the response to one person who wanted to add field 173 to their database:

HERE ARE THE STEPS FOR FIXING YOUR DATABASE:

  1. CREATE (OR MODIFY) YOUR FLEX REPORT (BIN) IN DEF.
  2. SPOOL YOUR RIS REPORT FOR BIN. (ENTIRE STORE)
  3. GO TO RDEF FROM THE EZ SOFTWARE MENU TO READ IN NEW REPORT DEFINITIONS FOR BIN.
  4. GO TO PCPRINT FROM THE EZ SOFTWARE MENU AND DOWNLOAD THE RIS REPORT. (SAVE AS SPREADSHEET) DBASE.DAT
  5. GO TO IMUP FROM THE EZ SOFTWARE MENU:
  6. CHOOSE ISTRUCTURE AND TAG FIELD 173 EXP CODES A.
  7. (SAVE NEW DEFINITION.)
  8. CHOOSE ERASE TO DELETE THE CURRENT IMU DATABASE.
  9. CHOOSE IREAD TO READ IN THE NEW FILE DBASE.DAT.
  10. YOU DATABASE WILL NOW INCLUDE FILED 173 AND YOUR "NUMBER OF FACINGS" LABEL FEATURE SHOULD NOW WORK CORRECTLY. (PROVIDED YOU USED ONE OF THE EXPANDED USER CODE A POSITIONS AS THE NUMBER OF LABELS NEEDED.)
 (Back to Top)