Developer/2000: Build Forms II
..........................................................................................
.
Volume 1 • Student Guide
44111GC10
Production 1.0
January 1998
M06178
Author
Pascal Gibert
Technical
Contributors and
Reviewers
Louise Barnfield
Gunnar Boehrs
Jacquelyn Bruce
Phyllis Chan
Bulent Cinarkaya
Laurent Dereac
Mark Doran
Gillian Elias
Tushar Gadhia
Stephen Gramann
Nancy Greenberg
Ursula Hovy
Uwe Jentzsch
Leta A. Johnson
Jan Keuben
Steve Lirette
Jayne Marlow
Rita Morin
Daphne Nougier
Christin Nowakowski
Bryan Roberts
Bert Salyga
Helene Schwann
Hiroyuki Sugiyama
Pal Tarcsay
Bart Van der Laar
Jack Walsh
Publishers
Stephanie Jones
Kelly Lee
Renee Voss
Copyright Oracle Corporation, 1998. All rights reserved.
This documentation contains proprietary information of Oracle Corporation. It is
provided under a license agreement containing restrictions on use and disclosure
and is also protected by copyright law. Reverse engineering of the software is
prohibited. If this documentation is delivered to a U.S. Government Agency of the
Department of Defense, then it is delivered with Restricted Rights and the
following legend is applicable:
Restricted Rights Legend
Use, duplication or disclosure by the Government is subject to restrictions for
commercial computer software and shall be deemed to be Restricted Rights
software under Federal law, as set forth in subparagraph (c) (1) (ii) of DFARS
252.227-7013, Rights in Technical Data and Computer Software (October 1988).
This material or any portion of it may not be copied in any form or by any means
without the express prior written permission of the Worldwide Education Services
group of Oracle Corporation. Any other copying is a violation of copyright law and
may result in civil and/or criminal penalties.
If this documentation is delivered to a U.S. Government Agency not within the
Department of Defense, then it is delivered with “Restricted Right,” as defined in
FAR 52.227-14, Rights in Data-General, including Alternate III (June 1987).
The information in this document is subject to change without notice. If you find
any problems in the documentation, please report them in writing to Education
Products, Oracle Corporation, 500 Oracle Parkway, Box 659806, Redwood
Shores, CA 94065. Oracle Corporation does not warrant that this document is
error-free.
Developer/2000, Oracle Server, and PL/SQL are trademarks or registered
trademarks of Oracle Corporation.
All other products or company names are used for identification purposes only,
and may be trademarks of their respective owners.
Developer/2000: Build Forms II iii
......................................................................................................................................................
...........................................................................................................................................................
Contents
Preface
Profile xi
Related Publications xii
Typographic Conventions xiii
Introduction I-1
Course Objectives I-3
Course Content I-5
Lesson 1: Managing Projects with Project Builder
Introduction 1-3
Introducing Project Builder 1-5
Project Builder Terminology 1-7
Project Builder Benefits 1-9
Project Builder User Interface 1-11
Creating Projects and Subprojects 1-13
Adding Project Files 1-15
Working with Project Files 1-17
Establishing Dependencies 1-19
Building Projects 1-21
Delivering Projects 1-23
Practice Session Overview: Lesson 1-1 1-25
Practice Session: Lesson 1 1-26
Inheritance in Project Builder 1-29
Defining New Types 1-31
Actions 1-33
Modifying Types Using Actions 1-35
Customizing Actions Using Macros 1-37
Customizing the Launcher 1-41
Summary 1-43
Practice Session Overview: Lesson 1-2 1-45
Practice Session: Lesson 1 1-46
Lesson 2: Creating a Menu Module
Introduction 2-3
Components of the Menu Module 2-5
Menu Styles 2-7
The Default Menu 2-9
The Menu Editor 2-11
Creating a Menu Module 2-13
Module Properties 2-15
Menu Properties 2-17
Menu Item Properties 2-19
Menu Item Types 2-21
Menu Item Command Types 2-23
Implementing Menu Toolbars 2-25
iv Developer/2000: Build Forms II
......................................................................................................................................................
.....................................................................................................................................................
.
Contents
Storing the Menu Module 2-27
Attaching the Menu Module 2-29
Pop-Up Menus 2-31
Summary 2-33
Practice Session Overview: Lesson 2 2-35
Practice Session: Lesson 2 2-36
Lesson 3: Managing Menu Modules
Introduction 3-3
Using PL/SQL in Menu Item Code 3-5
Useful Built-in Menu Subprograms 3-7
Showing and Hiding the Current Menu 3-9
Substitution Parameters 3-11
Defining a User-Named Substitution Parameter 3-13
Substitution Parameter Built-ins 3-15
Validating a Substitution Parameter Value 3-17
Managing Menu Security 3-19
Defining Security Roles 3-21
Assigning Access to Menu Items 3-23
Summary 3-25
Practice Session Overview: Lesson 3 3-27
Practice Session: Lesson 3 3-28
Lesson 4: Programming Function Keys
Introduction 4-3
Key Triggers 4-5
Defining Key Triggers 4-7
Characteristics of Key Triggers 4-9
Classification of Key Triggers 4-11
Using Key Triggers 4-15
Association with Other Interface Controls 4-17
Summary 4-19
Practice Session Overview: Lesson 4 4-21
Practice Session: Lesson 4 4-22
Lesson 5: Responding to Mouse Events
Introduction 5-3
What Are Mouse Events? 5-5
Responding to Mouse Movement 5-7
Responding to Mouse Button Actions 5-11
Summary 5-17
Practice Session Overview: Lesson 5 5-19
Practice Session: Lesson 5 5-20
Developer/2000: Build Forms II v
......................................................................................................................................................
...........................................................................................................................................................
Contents
Lesson 6: Controlling Windows and Canvases Programmatically
Introduction 6-3
Using Window-Interaction Triggers 6-5
Built-ins for Manipulating WINDOWS 6-7
Built-ins for Manipulating Canvases 6-9
Working with Tab-Style Canvases 6-11
Windows and Blocks 6-15
Manipulating Window Properties Programmatically 6-17
Showing Multiple Windows 6-19
Closing Windows 6-21
Using Large Blocks 6-23
Summary 6-25
Practice Session Overview: Lesson 6 6-27
Practice Session: Lesson 6 6-28
Lesson 7: Controlling Data Block Relationships
Introduction 7-3
Creating a Relation 7-5
Modifying a Relation 7-7
Block Coordination 7-11
Characteristics of Relation-Handling Triggers 7-13
Principles of Relation-Handling Code 7-15
Obtaining Relation-Handling Information 7-17
Implementing a Coordination-Type Toggle 7-19
Forcing a Commit Per Master 7-21
Summary 7-23
Practice Session Overview: Lesson 7 7-25
Practice Session: Lesson 7 7-26
Lesson 8: Building Multiple Form Applications
Introduction 8-3
OPEN_FORM to Invoke Additional Forms 8-5
Closing Forms 8-7
Navigating Between Forms 8-9
Transaction Processing for Opened Forms 8-11
CALL_FORM to Invoke Additional Forms 8-13
Transaction Processing for Called Forms 8-15
NEW_FORM to Invoke Additional Forms 8-19
Controlling Open Forms and Called Forms Together 8-21
Different Ways of Invoking Forms 8-23
Using Form Parameters 8-25
Parameter Lists 8-29
Creating and Manipulating Parameter Lists 8-31
Passing Data Between Forms 8-33
Summary 8-35