CONTENTS Title Page Copyright Page Preface 1 An Overview of RALLY 1.1 Oracle RALLY Run-Time System 1.1.1 RALLY Application Files 1.1.2 Relationship Among RALLY Application Objects 1.1.3 Sources of Data for RALLY Applications 1.1.4 Invoking RALLY Applications 1.2 Oracle RALLY Definition System 1.2.1 Sample RALLY Applications 1.2.2 Definition System Main Menu or Window 1.3 Character-Cell Interface 1.3.1 Using the Definition System Menus 1.3.2 Definition System Main Menu Options 1.3.3 RALLY Commands 1.3.4 Help Within RALLY: Legends and Help Text 1.3.4.1 Legends 1.3.4.2 Help Text 1.3.5 Lists of Values (LOVs) 1.3.6 Error Messages 1.3.7 Integrity Reports 1.3.8 Interrupting Your RALLY Session 1.4 Motif Interface 1.4.1 Differences Between the Motif and Character-Cell Interfaces 1.4.2 Invoking the RALLY Motif Interface 1.4.3 Using the RALLY Main Window 1.4.4 Editing RALLY Objects 1.4.5 Drawing Lines and Boxes 1.4.6 Getting Help in the Motif Interface 1.5 How to Create a RALLY Application 1.6 ADL-The RALLY Integrated Procedural Language 1.7 CDD/Repository Integration 1.7.1 Data Sources 1.7.2 Application Objects 1.8 Using RALLY with 3GL Code 1.9 RALLY Versus 3GLs 2 Features of RALLY Applications 2.1 Menus 2.2 Form/Reports 2.2.1 Usage Modes 2.2.2 Hierarchical Form/Reports 2.2.3 Lists of Values 2.2.4 Aggregates 2.2.5 Computed Fields 2.2.6 Validation 2.2.7 Local Functions 2.3 User Assistance Messages 2.4 Windows and Tasks 2.5 Macros 3 Building a Simple RALLY Application (Character-Cell Interface) 3.1 Creating the Application File 3.2 Creating the Database 3.2.1 Planning the Database 3.2.2 Creating the Database 3.2.3 Creating Domains 3.2.4 Creating a Table 3.3 Building a Data Source Definition 3.4 Building the Form/Report 3.5 Building the Main Menu 3.6 Testing Your Application 3.7 Making a Query 3.8 Advanced Features-Customizing Your Application 3.8.1 Creating a Child Group (Customers) 3.8.2 Adding a Field for the Current Date 3.8.3 Adding a Field and Text for the Page Number 3.8.4 Sorting the Salespeople 3.9 Going Forward with RALLY 4 Building a Simple RALLY Application (Motif Interface) 4.1 Creating the Database 4.2 Creating the Application File 4.3 Creating a Data Source Definition 4.4 Creating the Form/Report 4.5 Creating the Application's Menu 4.6 Testing Your Application 4.7 Making a Query 4.8 Advanced Features-Customizing Your Application 4.8.1 Creating a Child Group (Customers) 4.8.2 Adding a Field for the Current Date 4.8.3 Adding a Field and Text for the Page Number 4.8.4 Sorting the Salespeople 4.8.5 Editing the Menu 4.9 Going Forward with RALLY A RALLY Keypad Diagrams and Tables A.1 RALLY Keypad Diagrams A.2 RALLY Keypad Tables B Definition System Hierarchy Illustrations B.1 Edit application (3) B.2 Miscellaneous (5) FIGURES 1-1 Simplified Representation of a RALLY Application 1-2 Relationships Among RALLY Objects 1-3 Main Menu of the RALLY Definition System 1-4 Edit Application Menu 1-5 RALLY Command Line 1-6 Help on RALLY Commands 1-7 Legend in the Definition System 1-8 Help Information for Main Menu 1-9 Help: Overview of RALLY 1-10 List of Values Illustration 1-11 Error Message in the Definition System 1-12 Integrity Message 1-13 Some Motif Items in the RALLY Motif Interface 1-14 Main Window of the RALLY Motif Interface 1-15 Motif Interface DSD Editor 2-1 Menu Created Outside Builder Tools 2-2 Form/Report with Data from Different Sources 2-3 Data Entry Form Containing a List of Values 2-4 Form/Report with SUM Aggregate Field 2-5 Using Multiple Windows in a RALLY Application 3-1 Form/Report for Application to Be Created 3-2 Main Menu of the Definition System 3-3 Menu of the RALLY Database Tool 3-4 Form to Create a Database 3-5 Create a Domain Definition Form 3-6 Table Columns Defined 3-7 Form to Create Rdb-Based DSD 3-8 Form to Create a Form/Report 3-9 Groups in a Form/Report Form 3-10 Form to Create an Application Main Menu 3-11 Main Menu of the Application You Created 3-12 Salespeople Form/Report with Data 3-13 Form/Report with Extra Features 3-14 Defining the Child Group (G2) 3-15 New Location Coordinates 4-1 Form/Report for Application to Be Created 4-2 Main Window After Creating NEW_APPL 4-3 Form/Report Builder: Data Group 4-4 Main Menu of the Application You Created 4-5 Salespeople Form/Report with Data 4-6 Form/Report with Extra Features 4-7 Menu with Improved Appearance A-1 RALLY Editing Keys/LK Editing Keypad A-2 RALLY Form/Report Keys/LK Editing Keypad A-3 RALLY Editor Keys/EDT Keypad A-4 RALLY Form/Report Keys/EDT Keypad A-5 RALLY Editor/WPS Keypad A-6 RALLY Form/Report Keys/WPS Keypad TABLES 1-1 Key Assignments for Commonly Used Commands 1-2 Differences Between Character-Cell and Motif Interfaces 1-3 Comparison of Development with a 3GL and RALLY 3-1 Helpful Keys 3-2 Domains A-1 RALLY Commands That Have WPS Predefined Keys A-2 RALLY Commands That Have EDT Predefined Keys