Oracle Form Builder: Handling Multiple Object Relationships

This course is the fifth in a six-part Oracle Form Builder Series that is based on Oracle Developer/2000 Release 2. This course will help participants learn about Key triggers write applications that respond to mouse events manage windows and canvases and use Object Navigator. In addition users will work with multiple form applications record groups and list items.

This is primarily online training This is an online eLearning or CBT training program Contact Serebra Learning Corporation for more information

Duration: 8 hours Training Presented in: English

Audience

Application developers database administrators designer/developers and technical support professionals. Prior to taking this course participants should be familiar with SQL and PL/SQL using Procedure Builder or have taken courses 61110 61111 61112 and 60113. In addition participants should have taken the first four parts of the Oracle Form Builder series courses 61211 61212 61213 and 61214.

Objective

• Identify the rules types and functions of Key triggers.
• Write an application that responds to mouse events.
• Write the codes to manage windows and canvases by using builtins and triggers.
• Create and modify relations between two associated blocks by using Object Navigator and programmatic control.
• Invoke multiple forms by using builtins and pass data between forms by using parameter lists.
• Work with record groups.
• List items at design time and programmatically by using builtin functions.

Topics Include

Unit 1: Key Triggers and Mouse Events

• Create a Key trigger in a form module by using PL/SQL Editor.
• Identify the rules for defining Key triggers.
• Match the types of key triggers with their descriptions.
• Identify the functions of key triggers in a form module.
• Type in the PL/SQL code to associate a built-in with the DO_KEY built-in.
• Match the mouse system variables with their functions.
• Specify the mouse movement trigger for a specific function.
• Create a mouse button action trigger for a specified task by using PL/SQL Editor.
• Identify the guidelines to follow while implementing the drag-and-drop functionality.

Unit 2: Window and Canvas: RunTime Management

• Match the window-interaction triggers with their characteristics.
• Match the built-ins used for manipulating windows with their functions.
• Write the code to change the appearance of a window in a form by using built-ins.
• Write the code to display multiple windows at specified positions in a form by using the built-ins.
• Write the code to close a window by using built-ins.
• Match the built-ins for manipulating canvases with their functions.
• Write the code to manipulate tab-style canvases by using built-ins.

Unit 3: Data Block Relationships

• Create an explicit relation between two associated blocks by using the New Relation dialog box.
• Modify the delete behavior between related blocks by using the relation Property Palette.
• Modify the query coordination behavior between related blocks by using the relation Property Palette.
• Identify the block-coordination phases in a relation.
• Identify the features of the default relation-handling triggers.
• Match the default relation-handling procedures with the triggers that call them.
• Write the code to implement the coordination-type toggle between blocks by using built-ins.
• Write the code to implement the coordination-type toggle between blocks by using built-ins.

Unit 4: Working with Multiple Form Applications

• Identify the behavior of a multiple form application.
• Identify the methods by which multiple form modules in an application share information.
• Identify the built-ins used to programmatically invoke another form module.
• Write the code to invoke a form module in a modeless fashion by using a built-in.
• Write the code to perform a query at form startup by using a trigger.
• Match the built-ins used for navigating forms with their descriptions.
• Identify the features of transaction processing for opened form modules.
• Write the code to call a form module in a modal fashion from an open form module by using the built-in.
• Write code to modify the default functionality of transaction processing for called forms.
• Write the code to invoke a new form after exiting the current form by using a built-in.
• Identify the restrictions on using OPEN_FORM with CALL_FORM.
• Match the various methods of invoking forms with the tasks they enable you to perform.
• Create a form parameter by using the Object Navigator.
• Match the built-ins used for manipulating parameter lists with their functionality.
• Write the code to pass data between forms by using the form parameters.
• Write the code to close a form by using the CLOSE_FORM built-in.
• Write the code to close a form by using the EXIT_FORM built-in.

Unit 5: Record Groups and List Items

• Identify the uses of record groups.
• Match the record group types with their functionality.
• Create a query record group at design time by using the Object Navigator.
• Create a static record group at design time by using the Object Navigator.
• Modify a record group at design time by using the Property Palette.
• Match the built-ins used to manage the record group structures with their functionality.
• Identify the built-ins used to manage the data in record groups.
• Match the built-ins used to process record group rows with their functionality.
• Identify the built-in functions that are used to search for record group objects.
• Define a query record group by using built-ins.
• Define a non-query record group by using built-ins.
• Write the code to manipulate record group rows by using built-ins.
• Write the code to manipulate selected record group rows by using built-ins.
• Identify the built-ins used for manipulating list items.
• Write the code to implement dynamic list item by using built-ins.
• Write the code to add values to a combo box list item at runtime by using built-ins.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

CDROM

• Oracle Form Builder: Enhancing the User Interface
• Oracle Form Builder: Forms Fundamentals
• Oracle Form Builder: Including Reusable Oracle Components
• Oracle Form Builder: Managing Module Types
• Oracle Form Builder: Writing and Debugging Code