https://dataflex.wiki/api.php?action=feedcontributions&feedformat=atom&user=Chuckatkinson 2026-04-30T15:15:02Z User contributions MediaWiki 1.43.8 https://dataflex.wiki/index.php?title=Data_Dictionaries&diff=1216 2007-11-25T19:17:00Z

<p>Chuckatkinson: /* Supported backends */</p> <hr /> <div>'''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.<br /> <br /> The [[Database Builder]] tool helps you defining the class with visual aid for:<br /> *Field settings like ''Capslock'' <br /> *Table settings like calculations on save or save/delete validations<br /> *Relationship settings like [[Cascade Delete]].<br /> <br /> The Datadictionary class can also contain and business rules required when records are created, edited or deleted.<br /> <br /> ==How to create a new Data Dictionary from scratch==<br /> <br /> #Open [[Database Builder]].<br /> #Create a new table<br /> #Enter some columns (input name, type and width)<br /> #Choose '''Maintenance''' and '''Create Empty DataDictionary'''.<br /> <br /> NOTE: remember to enter a width for your column.<br /> <br /> ==How to create Relationships==<br /> <br /> Before creating relationships, make sure that both tables should have an index. <br /> *use 'the relationship wizard' in the database builder.<br /> <br /> =Supported backends=<br /> <br /> It is possible to reach several databases through the Data Access [[DataFlex Connectivity Kit]] or using third party<br /> drivers from Mertech Data [http://mertechdata.com/rainbow/site/1/default.aspx]<br /> <br /> *Native Dataflex database<br /> *[[Oracle]] [http://wiki.oracle.com/page/Database]<br /> *[[Microsoft SQL Server]] [http://msdn2.microsoft.com/en-us/sql/default.aspx]<br /> *[[Pervasive]] [[SQL]]<br /> *[[ODBC]]<br /> *[[MySQL]]<br /> <br /> [[Category:Basics]]</div>

Chuckatkinson