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 Database Builder 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.

Supported backends

• native dataflex database
• Oracle
• Microsoft SQL server
• pervasive sql
• ODBC
• MySQL