Data Dictionaries

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

1. Open Database Builder.
2. Create a new table
3. Enter some columns (input name, type and width)
4. 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

• Native Dataflex database
• Oracle [1]
• Microsoft SQL Server [2]
• Pervasive SQL
• ODBC
• MySQL