Data Dictionaries: Difference between revisions

From DataFlex Wiki
Jump to navigationJump to search
No edit summary
mNo edit summary
Line 1: Line 1:
DataDictionaries are about the most important thing in the DataFlex world. They provide a class layer between your application and the database 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:
The [[Database Builder]] 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

Revision as of 11:52, 25 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 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

Retrieved from "https://dataflex.wiki/index.php?title=Data_Dictionaries&oldid=1167"