Oracle 8 and 8i Features in Forms Developer
IN THIS CHAPTER
- 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
Programming with objects involves using object tables (entire tables based on a single object type), VARRAYS, nested tables, REF columns , and stored procedures returning one of these object values. Oracle Developer 6.0 onwards has introduced the capability of performing CRUD (Create, Retrieve, Update, Delete) operations on block data sources based on some of these object categories. Also it has the capability of using some features of PL/SQL 8 from Forms and of incorporating JavaBeans components into Forms applications. This chapter explores these capabilities in greater depth. The remainder of this chapter is organized as follows :
- Techniques for querying and updating new data sources in Forms based on objects that includes CRUD on object table-based data sources in Forms and CRUD on object type-based items in Forms
- A new look at relations using REFs
- Record groups based on objects
- PL/SQL8 and 8i capabilities in Forms, including limitations
- Limitations of Forms in handling objects, including the inability to handle VARRAYS and nested tables involving objects stored in the database
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
