Create a New Database

Create a new database as follows:

  1. Select System | Databases | Maintenance > Define Structure.
  2. Enter a name for the new database.
    • Name the new database in capital letters in the format d_DATABASE_NAME.
    • The maximum length of a name is 16 characters.
    • You may use underscores (_) in the name.
    • You can leave out the prefix d_ in front of the name, the program adds it in front of the name.
  3. Select the save folder. By default, databases will be saved in the ../shared/dbases folder.
  4. Click Save.
  5. Confirm creating the new database by selecting Yes.
    The program opens the Edit Database Format window, where all fields are empty.
    • On the left is the current definition in the fields Old Field Name, Old Index and Old Type.
    • You can edit the fields New Field Name, New Index and New Type on the right.
  6. Add a new field to the database by using the context-sensitive function:
    • Add row after or
    • Add row before or
    • Copy row.
  7. Enter the name in the field New Field Name.
    • When naming fields, please note that the allowed characters are the numbers (0-9), the letters (a-z, A-Z) and the underscore (_).
  8. If necessary, select an index in the New Index field.
    • Select blank as the index for most of the fields so that database processing is not slowed down unnecessarily.
    • IND = Index the database based on this field.
    • UNIQUE = Defines the field as unique, meaning the field cannot have the same value in more than one row in the database.
  9. Define the field's Unicode type and length in the New Type field.
    • T = Text field, for example T15.
    • M = Alphanumeric field, for example M20.
    • N = Numeric field, for example N8.
    • The types A and B in the old installations should be replaced with the Unicode type fields T and M.
  10. Confirm the database format by clicking OK.