Data Dictionaries

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.