Data Dictionaries: Difference between revisions
From DataFlex Wiki
Jump to navigationJump to search
mNo edit summary |
Hellboy1975 (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
'''Data Dictionaries''' are a class layer between your application and the database tables. They are considered to be a vital part of any Dataflex development. | |||
The [[Database Builder]] helps you defining the class with visual aid for: | The [[Database Builder]] tool 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 | ||
*Relationship settings like Cascade | *Relationship settings like [[Cascade Delete]]. | ||
The Datadictionary class can also contain and business rules required when records are created, edited or deleted. | |||
==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. | NOTE: remember to enter a width for your column. | ||
== How to create | ==How to create Relationships== | ||
Before creating relationships, make sure that both tables should have an index. | |||
*use 'the relationship wizard' in the database builder. | *use 'the relationship wizard' in the database builder. | ||
=Supported backends= | =Supported backends= | ||
* | *Native Dataflex database | ||
*[http://wiki.oracle.com/page/Database | *[[Oracle]] [http://wiki.oracle.com/page/Database] | ||
*[http://msdn2.microsoft.com/en-us/sql/default.aspx | *[[Microsoft SQL Server]] [http://msdn2.microsoft.com/en-us/sql/default.aspx] | ||
* | *[[Pervasive]] [[SQL]] | ||
*ODBC | *[[ODBC]] | ||
* | *[[MySQL]] | ||
[[ | |||
[[Category:Basics]] | [[Category:Basics]] | ||
Revision as of 11:38, 25 November 2007
Data Dictionaries are a class layer between your application and the database tables. They are considered to be a vital part of any Dataflex development.
The Database Builder tool 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.
The Datadictionary class can also contain and business rules required when records are created, edited or deleted.
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
Before creating relationships, make sure that both tables should have an index.
- use 'the relationship wizard' in the database builder.
