Data Dictionaries: Difference between revisions

From DataFlex Wiki
Jump to navigationJump to search
No edit summary
No edit summary
Line 2: Line 2:


The DBBuilder helps you defining the class with visual aid for:
The DBBuilder helps you defining the class with visual aid for:
- Field settings like Capslock  
*Field settings like Capslock  
- Table settings like calculations on save or save/delete validations
*Table settings like calculations on save or save/delete validations
- Relationship settings like Cascade delete  
*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.