Data Dictionaries

From DataFlex Wiki
Revision as of 06:35, 23 November 2007 by Marco (talk | contribs)
Jump to navigationJump to search

DataDictionaries are about the most important thing in the DataFlex world. They provide a class layer between your application and the database tables.

The DBBuilder helps you defining the class with visual aid for:

  • Field settings like Capslock
  • Table settings like calculations on save or save/delete validations
  • Relationship settings like Cascade delete

how to create a new data dictionary from scratch

  • open Database Builder.
  • create a new table
  • enter some columns (input name, type and width)
  • choose "Maintenance" and "create empty datadictionary"

NOTE: remember to enter a width for your column.

How to create relationships

  • both tables should have an index.
  • use 'the relationship wizard' in the database builder.