Linker IT Software
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Oracle Designer - building data relationships (Read 3795 times)
Gerrit-Jan Linker
YaBB Administrator

Posts: 75
Oracle Designer - building data relationships
22.02.08 at 10:38:06
Oracle Designer - Building data relationships
Data view for the module does not automatically display inherent or designed data relationships. To reproduce the relationships between tables already specified in Designer choose Utilities | Default Links. The utility allows you to automatically generate links that specify how the module component tables are to be used in constructing a generated application. The type of links that are generated by this utility are referred to as key based links.
If you have based a module component on a view no foreign keys will be available to make the data relationships. This can be fixed by creating a dummy foreign key on the view. In Designer add a foreign key to the view in the Server Model. When generating the view no change is made to the generated code, i.e. no foreign key is attempted to be made physically in the database. However with the foreign key you can now use this view in the module component. The button "Key based link" can be used in the module diagram to create the link.
Back to top
« Last Edit: 03.04.08 at 08:12:26 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1