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 | 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 10: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
- native dataflex database
- Oracle
- Microsoft SQL server
- pervasive sql
- ODBC
- MySQL
