Programmatic Equivalent of Cancel Query
Here's a technique that is the equivalent of selecting the Cancel Query button when the form is in Enter Query mode. The technique used is simple but not conspicuous as we use the KEY-EXIT trigger. Write a KEY-EXIT trigger with the Fire In Enter-Query Mode property set to TRUE (in Forms 4.x) and to Yes in higher versions:
KEY-EXIT EXIT_FORM(NO_VALIDATE);
Note that programmatically simulating Cancel Query in Enter-Query mode is not the same as ABORT_QUERY. Simulating Cancel Query is aborting Enter Query mode.
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
