Data Dictionaries
From DataFlex Wiki
Data Dictionaries are a class layer between your application and the database tables. They are considered to be a vital part of any Dataflex development.
The Database Builder tool 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.
The Datadictionary class can also contain and business rules required when records are created, edited or deleted.
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
Before creating relationships, make sure that both tables should have an index.
- use 'the relationship wizard' in the database builder.
Supported backends
It is possible to reach several databases through the DataFlex Connectivity Kit
