Oracle Developer Forms Techniques

Chapter 8. Additional Interesting Techniques

IN THIS CHAPTER

• 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

This chapter presents some interesting techniques regarding cancellation of a query programmatically; the processes of navigation and validation; and defining triggers at multiple levels. The initial two sections explain techniques of programmatically canceling a query and the programmatic ...