Sample Chapter

Topics

Place an Order

Home

Related Links

Learning Oracle Form Builder 5.0

Chapter 1: Getting Started

• Starting Form Builder
• Quitting Form Builder
• The Starting Screen
• About Form Builder
• The Object Navigator
• The Form Builder Designer Window
• Creating a New Form

Chapter 2: Creating a Default Master-Detail Form

• Creating a Single Record Block
• Changing Display Labels
• Changing the Block Name
• Creating a Multi-Record Block
• Defining a Master-Detail Relation
• The Property Palette
• Saving Your Work
• Generating the Form
• Running the Form
• Saving While You Read

Chapter 3: Modifying the Form

• Default Order By
• Modifying Text Items
• Testing the Changes

Chapter 4: Changing the Default Blocks

• Moving Objects on the Screen
• Testing the Changes
• Adding A Text Item to the Items Block
• Labeling the New Text Item
• Testing the Changes
• Adding A Text Item to the Orders Block
• Testing the Changes
• Adding a Button Palette
• Testing the Changes

Chapter 5: Lists of Values

• Customer LOV
• Testing the Customer LOV
• Product LOV
• Testing the Product LOV

Chapter 6: Triggers

• Trigger Categories
• HELP on Triggers
• A Trigger to Validate the Customer ID
• Compiling a Trigger
• Testing the WHEN-VALIDATE-ITEM Trigger
• PL/SQL Procedure GET_CUSTNAME
• A Post-Query Trigger
• Testing the WHEN-VALIDATE-ITEM and POST-QUERY Triggers
• PRODID Triggers
• PL/SQL Exceptions
• Testing the GET_PRODDESC and GET_CUSTNAME Procedures
• Button Triggers
• The DO_KEY Built-In Procedure
• The EXIT Button
• Testing the Buttons
• Calculation Triggers
• A Trigger to Validate the ACTUALPRICE Entry
• Creating An Alert Box
• Testing the Alert Box
• A Trigger to Calculate the Totals
• NEXT RECORD Trigger
• Testing the Calculation Triggers
• Sequence Number Triggers
• Sequence Generators
• Programmatic Generation of the Sequence Number
• Placing the Sequence Trigger
• A Trigger to Fetch a Sequence Number
• Testing the KEY-COMMIT Trigger
• Placing the Sequence Trigger, Part II
• A PRE-INSERT Trigger to Fetch the Sequence Number
• Deleting the KEY-COMMIT Trigger
• Testing the PRE-INSERT Trigger
• More on Sequence Generators
• A Trigger to Verify the Standard Price
• Revising the PL/SQL Procedure GET_PRODDESC
• Testing the Price Trigger
• A Trigger to Make the LOVs More Operator-Friendly
• Testing the LOV Trigger
• Enforcing Data Model Rules
• Testing the KEY-COMMIT Trigger

Chapter 7: Appearances

• Selecting All Objects
• Shrinkwrap
• Resizing the Canvas View
• Fonts and Text
• Changing Object Attributes
• Changing Display Label Fonts
• Grouping Objects
• Importing Images
• Overlaying Objects
• Adding Radio Buttons
• Testing the Radio Buttons
• Property Classes
• Applying a Property Class

Chapter 8: Libraries

• Creating a Library
• Attaching a Library
• Adding Triggers to Use the Library
• Testing the Library Procedure
• Maintaining a Library
• Stripping Source Code from the .PLL File
• Object Libraries
• Creating an Object Library
• Saving the Object Library

Chapter 9: Menus

• The Default Menu
• Building a Default Customer Form
• Copying Objects from the Object Library
• Automatic Querying
• A Sample Menu
• Customizing a Menu
• Navigating in the Menu Editor
• Adding a Main Menu Choice
• Adding a Submenu Choice
• Global Variables
• Deleting Menu Items
• Generating the Menu
• Attaching the Menu
• Updating the Customer Form for Automatic Query
• Testing the Menu

Chapter 10: Debugging

• Fixing the Century
• Creating the FIX_CENT Library
• The NAME_IN and COPY Built-In Procedures
• The FIX_CENTURY Procedure
• Adding a Trigger to Use the Library
• The Debugger
• System Variables
• Coding for Portability
• A Property Class for Dates
• Another Solution

Chapter 11: Canvasses

• Types of Canvasses
• Creating Canvasses
• Using the Tab Canvas
• Testing the Canvas