Oracle Developer Forms Techniques

ISBN: 0672318466
EAN: 2147483647

Year: 2005
Pages: 115

Authors: Bulusu Lakshman

BUY ON AMAZON

GUI Development

• GUI Development
• Standard Toolbar Implementation
• Timers and Displaying a Clock
• Special Tips for List Items
• Ordering by Foreign Key Items in Forms
• Querying by Nonbase Table Items
• Tips for Standard GUI Practices and Forms Development
• Summary

Advanced GUI Development: Developing Beyond GUI

• Advanced GUI Development: Developing Beyond GUI
• Playing with Relations
• Obtaining Query Count Without EXECUTE-ing a Query
• Using Form and Global Variables
• Base Tables
• The Power of Record Groups
• Creating a Customized Sign-on Form
• Avoiding Confusion Between DO_KEY and the Corresponding KEY- Trigger
• Window Management in Forms
• Summary

Multi-form Applications

• Multi-form Applications
• Myths About the Form Filename, Form Module Name , and Form ID
• Passing Data from the Called Form to the Calling Form
• Form Management in an OPEN_FORM Configuration
• Tracking QUERY_ONLY Mode
• Special Tips for Working with Multi-form Applications
• Summary

Advanced Forms Programming

• Advanced Forms Programming
• The Work-around for PL/SQL 2.x Limitations in Forms 4.5
• Populating a PL/SQL Table from a Block
• Taking Advantage of PL/SQL 2.x in Forms
• File Output from a Block
• An Exclusive Server-Side Commit from Forms
• Intersession and Interdatabase Communication from Forms
• Sharing a Record Group Across Forms
• Summary

Error-Message Handling

• Error-Message Handling
• The Basics of Error-Message Handling
• Handling Errors
• Deficiencies in Forms Error-Message Handling
• Summary

Object-oriented Methods in Forms

• Object-oriented Methods in Forms
• Inheritance
• Encapsulation
• Object and Code Reusability
• Polymorphism
• Summary

Intelligence in Forms

• Intelligence in Forms
• Smart Classes and Smart Triggers - How Smart Are They?
• Does Subclassing Exhibit Intelligence?
• Normal Trigger Intelligence
• Intelligence with Regard to Form Object Properties
• Intelligence with Regard to Form Wizards
• Summary

Additional Interesting Techniques

• Additional Interesting Techniques
• Programmatically Canceling a Query
• Programmatic Equivalent of Cancel Query
• Validation, Navigation, and Simulating Navigation
• Enhancing the Function of Exit Form
• Preventing Validation of WHEN-VALIDATE-ITEM for Control Items During Query Time
• When to Use WHEN-VALIDATE-RECORD and When to Use WHEN-VALIDATE-ITEM
• When to Use the Same Trigger and How to Make It Fire at Multiple Levels
• A Block Level Commit
• Summary

Working with Trees

• Working with Trees
• Creating a Tree Item
• Operations on a Tree Item
• Planting and Growing Trees -Dynamically Adding Nodes Along with Data to an Existing Base Tree
• Shrinking Trees
• Summary

Oracle 8 and 8i Features in Forms Developer

• Oracle 8 and 8i Features in Forms Developer
• Techniques for Querying and Updating New Data Sources in Forms Based on Objects
• A New Look at Relations Using REFS
• Basing a Block on a Stored Procedure Involving Object Tables
• Record Groups and LOVs Based on Objects
• Summary