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 | 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 06: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.