Data Dictionaries: Difference between revisions

From DataFlex Wiki
Jump to navigationJump to search
No edit summary
No edit summary
Line 1: Line 1:
DataDictionaries are about the most important thing in the DataFlex world. They provide access to your dataflex tables.
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==
== how to create a new data dictionary from scratch==

Revision as of 07:35, 23 November 2007

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.