Sams Oracle Developer Forms Techniques

Oracle Developer Forms Techniques
By Bulusu Lakshman

Publisher : Sams Publishing
Pub Date : February 18, 2000
ISBN : 0-672-31846-6
Pages : 264
Slots : 1


Copyright
About the Author
Acknowledgments
Tell Us What You Think!
Introduction
What's New
The Structure of This Book
Intended Audience
Conventions Used in This Book
Chapter 1. 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
Chapter 2. 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
Chapter 3. 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
Chapter 4. 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
Chapter 5. Error-Message Handling
The Basics of Error-Message Handling
Handling Errors
Deficiencies in Forms Error-Message Handling
Summary
Chapter 6. Object-oriented Methods in Forms
Inheritance
Encapsulation
Object and Code Reusability
Polymorphism
Summary
Chapter 7. 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
Chapter 8. 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
Chapter 9. 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
Chapter 10. 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
PL/SQL8 and 8i in Forms
Summary
Index

Download
Another Database books