|
|
| (9 intermediate revisions by 5 users not shown) |
| 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.
| | Plural for [[DataDictionary]] |
| | |
| 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
| |
| *[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]] |
Latest revision as of 13:11, 4 March 2020
