Oracle Designer Tutorial |
Once the analysis data is as complete as possible and the database design is stable and complete, you are ready to create a first-cut application design based on information stored in the repository.
The Oracle Designer utility to produce the first-cut application design is the Application Design Transformer. The Application Design Transformer converts functions into candidate modules, which can then be implemented as forms, reports and utilities. The Application Design Transformer also converts function data usages to module data usages that define how a module uses the tables and columns in the database.
The modules created by the Application Design Transformer are 'candidate' modules and are not included in the application design until you accept them (by changing their 'Candidate' property to 'No'). Modules you accept, and their usages, can then be used for generating applications.
Note: You can follow lessons 7 through 9 only if Oracle Forms has been installed.
To create module definitions for the automated functions.
You do this by selecting FileNew, setting the default container to TUTORIAL (1), then double clicking
on AUTO 1 in the New Diagram dialog box. You may have to resize the diagram to see all of the functions.
This opens the Application Design Transformer dialog box.
Common Parameters - Start Function | AUTO 1 |
Common Parameters - Module Prefix | TUTORI |
Note: If you leave this option set to the default (i.e., Identical Entities), the Application Design Transformer will create a single module definition for functions DELI 10.4 (AUTO) and DELI 10.5 (AUTO). This single module definition will not enable you to continue with the tutorial.
The Application Design Transformer has created "candidate" module definitions. These will not be used for generation unless you change this status.
To make the default module definitions ready for generation.
The properties for the module are shown in the Property Palette.
The property names for a particular object are listed in the cells in the left column. The values for the properties are listed in the cells in the right column. When you click on a values cell, it changes to an appropriate input control. The controls you will be using include the drop-down box and the list box. When using the list box, you obtain the list of possible values by clicking the icon on the right of the cell.
The changes that you make to the values of a particular object (in this case module definitions), will be saved automatically if you display the values for another object. You can also save the values manually.
To save the changes that you make on the Property Palette manually, select FileSave Uncommitted
Data, or click
on the Property Palette toolbar.
The icon for the first module changes to represent a Report.
The icons for the modules will change to represent various module languages.
Leave the Design Editor open for the next stage.
You can now generate a first-cut working form. The generated form will provide basic functionality that you can refine in later lessons.
To generate a default working form from a module definition.
Progress is reported in the message window.
The Build Action dialog box is displayed.
The default working form will be similar to this.
You can use this form now if you wish. The details that you enter will be recorded on the PRICED_PRODUCTS and PRODUCTS tables of the database that you generated earlier. Note that the fields may not appear in exactly the same order as those in the example above.
The cursor will be flashing in the Discout Day field.
Type 1 into the Discount Day field.
Tab to the Product Description field and type in Ham and mushroom supreme.
Tab to the Product Id field and type in 1001.
Tab to the Product Type field and type in PIZZA.
Choose Action Save to save the information to the database. The message "Transaction
complete - 1 record applied and saved" is shown at the foot of the window.
Make further entries if you wish (e.g., for a beverage), but not too many at this stage.
Now click the Product Id field and type in 1001. This is the product identity number that you previously entered for "Ham and mushroom supreme".
Tab to the Price field and enter 9.99.
Tab to Label and type in Medium Ham and Mushroom Supreme.
Tab to the Size Code field. Choose Edit Display List to see a list of valid values, highlight M Medium and click
OK.
Tab to Quantity In Stock but don’t enter a value.
Choose Action Save to save the information to the database.
Make a few more entries, if you wish.
You will have noticed that the fields on the form are held within two blocks, one relating to the Priced Products table and one to the Products table. In the next lesson, the Products table will be made into a lookup table and you will enter only Priced Products information through the generated form.
Leave the Design Editor open for the next lesson.
In this lesson you:
|
|