Data Dictionaries: Difference between revisions
From DataFlex Wiki
Jump to navigationJump to search
m DataDictionaries moved to Data Dictionaries: tidying up a bit |
No edit summary |
||
| Line 19: | Line 19: | ||
*both tables should have an index. | *both tables should have an index. | ||
*use 'the relationship wizard' in the database builder. | *use 'the relationship wizard' in the database builder. | ||
=Supported backends= | |||
*native dataflex database | |||
*[http://wiki.oracle.com/page/Database Oracle] | |||
*[http://msdn2.microsoft.com/en-us/sql/default.aspx Microsoft SQL server] | |||
*pervasive sql | |||
*ODBC | |||
*MySQL | |||
[[Category:Stub]] | |||
[[Category:Basics]] | [[Category:Basics]] | ||
Revision as of 10:41, 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 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.
Supported backends
- native dataflex database
- Oracle
- Microsoft SQL server
- pervasive sql
- ODBC
- MySQL
