A Block Level Commit
Summary
This chapter deals with the often required techniques in Forms query processing and validation and navigation. The techniques for programmatically canceling a query and the programmatic equivalent of Cancel Query while in Enter Query mode were discussed. The subtle differences between WHEN-VALIDATE-ITEM and WHEN-VALIDATE-RECORD triggers and an enhanced Exit Form functionality were highlighted. Finally, the usage of the same trigger at multiple levels was discussed and the idea of a block-level commit was presented.
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
EAN: 2147483647
Pages: 115
