Detailed Topics
Database Reverse Engineering and Reconciliation
- Reconciliation
- Select Objects to Reconcile
- Reconciliation Report
- Alter Database
- Reverse Engineering a Database
- Select Objects to Reverse Engineer (Database)
- "Retrofit" Report
- Reverse Engineer from File
- Parser Status
- Table to Entity Reverse Engineering
Using the Preferences Navigator
- Preferences Navigator Features
- Selecting Product Flavor and Application
- Preference Levels
- "Where Set" Icons
- Node Type Terminology
- Navigator Preferences (Hierarchy Window)
- Navigator Preferences (Properties Window)
- Navigator Preferences (Common)
- Filtering Displayed Preferences
- More Filtering in Hierarchy Window
- Expanding and Collapsing Nodes
- Module and Associations Only
- String Searching and Marking
- Instance Searching
Managing
Preferences
- Setting Preferences
- Unsetting Preferences
- Copying and Pasting Preferences
- Copy Using Drag and Drop
- Cascade Unset
- Pinning and Unpinning Property Windows
- Protecting Preferences
- Freezing Preferences
- Determining User Preference Set at Generation
Managing
Named Sets
- Named Set Features
- Creating Named Sets
- Viewing Named Sets
- Referencing and Dereferencing
User
Preferences
- Generator Runtime Options and Features
- User Interface Features
- Validation
- Validation for Column/Domain Valid Values
- Coding Style and Comments
- Scope of Reference Code and Help Tables
Extended Form Functionality
- Derived Base Table Items
- Maintaining Base Table Items
- Derived Non-base Table Items
- Summary Items for Forms
- Creating Forms Summary Functions
- Empty Non-base Table Items
- Restricting Queries and Enhanced FK Validation
- Additional Column Validation
List
of Values
- Standard List of Value (LOV) Features
- Lookups in LOV
- LOV Buttons
- LOV Positioning and Sizing
- LOV for Column/Domain Valid Values
Miscellaneous
Features
- Lookup Items May Replace FK Items
- Calendar Tools
- Including Calendar Window
- Current Record Indicator
- Message and Error Handling
Forms
Calling Forms
- Module Structure Diagrammer
- Regular Forms Calling Forms
- LOV Forms
- Creating LOV Forms
Form
Layout Overview
- CASE Terminology
- Layout Item Types With User Preference Group for Each
Type
- Layout Features
Block
Layout
- Block Layout Features
- Block Item Layout (Tabs)
- Block Item Layout (Fill)
- Layout Relative to 2-Dimensional Items
Block
Placement
- Block Positioning and Row Layout
- Block Placement Process
- Same Page
- New Page
- New Window/ New Page
- New Popup
- Two New Popups
- Same Popup With Non-consecutive DTUs
Overflow
Options
- Sizing, Wrapping and Overflow
- Spreadtable Layout
- Overflow Area
- Page and Window Sizing
- Page Expansion
Block
Synchronization
- Block Synchronization Issues
- Block Synchronization Modes
- User Autoquery Toggle
Item
Groups
- Item Group Layout
- Stacked Item Groups
- Creating Item Groups
- Creating Item Groups in Diagrammer
- Context Area (aka "Copy Over Context")
- Item Groups in Context
- Block Stubs
- Window Layout
GUI
Items
- GUI Items
- Radio Groups
- Checkboxes
- Poplists
- Text Lists
- Buttons
- Combo Boxes
- Image Items
- Single Area Image Item Layout in Multi-Row Blocks
Text
Items
- Text Item Layout
- Two Part Prompts
- Default Text Item Layout Preferences
Form
Templates
- Template Overview
- Template Windows
- Template Canvases
- Generated Page Example
- Generator and User Items
- Generator Items
- Generated Item and Trigger Example
- Interesting Generator Items
- Stacked Headers and Footers
- Headers and Footers (non-stacked)
- Toolbars
- Visual Attributes
- NVA Example with Graphic Background
Reverse
Engineering
- Overview
- Reverse Engineering Dialog
- Selecting From File System
- Reverse Engineering from Database
- Detailed Usages
- Summary Usages
- Creating Additional Usages
Regeneration
- Overview
- Generated Code
- What Gets Regenerated
- Inhibiting Regeneration
- When to Use Regeneration
Generator
for Reports
- Overview
- Report Features
- Generating Reports
- Table Details
- Table Text
- Column Details
- Column Display
- Column Text
Module Format and Layout Styles
- Report Module Definition
- Module Formats and Layout Styles
- Form Style
- Tabular Style
- Across Style
- Address Style
- Master Detail Module Format
- Control Break Module Format
- Matrix Module Format
- Label Module Format
- Override Example
Break
Groups
- DCU Break Groups
- Break DCU Setup
- Two Level Break Example
- Two Column Break Group Example
Data
Model
- Report DTU and DCU Linking
- Dept Base, Emp Base
- Emp Base, Dept Lookup
- Aggregate Queries
- Creating Aggregate Queries
- Subqueries
- Refining Subqueries
- NOT IN (SELECT ...) Example
- Matrix Reports
- Matrix Linking
Summary
Functions
- Overview
- Creating Summary Functions
Report
Arguments
- Argument Usage
- User Argument Screen
- Argument Definition (RON)
- Argument Definition, Module Dialog
- Validation
Runtime and Other Preferences
- Runtime and Miscellaneous Preferences
Detailed Group Frame Layout
- Features
- Relative Positioning of Frames
Positioning Objects within Frames
- Features
- Other Objects
- Field and Prompt Spacing
Report
Templates
- Templates Determine Fonts, Visual Attributes and
Boilerplate
- Generator Objects
- Fonts and Visual Attributes
- Interesting Generator Items
Report Reverse Engineering Overview
SQL*Plus
Lab
Exercises
Introduction
to Labs
- Lab 1 - Objectives
- Lab 2 - SQL*Sporting Goods Sold to CONSART
Database Reverse Engineering and Maintenance
- Lab 1 - Introduction
- Lab 2 - Create an Application System
- Lab 3 - Create a Database
- Lab 4 - Setup for Reverse Engineering
- Lab 5 - Reverse Engineering
- Lab 6 - Table to Entity Retrofit
- Lab 7 - Reconciliation and Alteration
Using the Generator and User
Preferences
- Lab 1 - Preparation
- Lab 2 - Understanding Preference Levels
- Lab 3 - Navigating Preferences
- Lab 4 - Filtering
- Lab 5 - Copying Preference Sets
- Lab 6 - Using Other Modules Preferences
- Lab 7 - User Interface Features
Derived and Summary Items
- Lab 1 - Base Table Item Derivations
- Lab 2 - Non-base Table Item Derivations
- Lab 3 - Summary Items
Restricted Queries & FK
Validation
- Lab 1 - Restricting Base Queries
- Lab 2 - Restricting Non-base Queries
Forms Calling Forms, Lookups &
Alerts
- Lab 1 - Alerts
- Lab 2 - Lookup Item Features
- Lab 3 - LOV Forms
- Lab 4 - Regular Forms Calling Forms
Block
Layout
- Lab 1 - Block Appearance
- Lab 2 - Block Item Layout
- Lab 3 - Block Positioning - Same Page
- Lab 4 - Same Page, New Page
- Lab 5 - Same Page, Popup, Same Page
- Lab 6 - Same Page, New Window
Item
Groups
- Lab 1 - Base Groups
- Lab 2 - Global Groups
- Lab 3 - Copy Over Context
GUI
Items
- Lab 1 - Checkboxes
- Lab 2 - Radio Groups
- Lab 3 - Poplists
- Lab 4 - Text Lists
- Lab 5 - Image Items
- Lab 6 - Text Items
Templates
- Lab 1 - Adding Generator Items
- Lab 2 - "Regular" Headers and Footers
- Lab 3 - BONUS LAB: Graphics Boilerplate
Reverse Engineering and Regeneration
- Lab 1 - Reverse Engineering
- Lab 2 - Regeneration
Report Format and Layout Styles
- Lab 1 - Module Formats
- Lab 2 - Layout Styles
Break
Groups
Data
Model
- Lab 1 - Aggregates
- Lab 2 - Subqueries
- Lab 3 - Matrix Reports
Summary
Functions
- Lab 1 - Summary Functions
Copyright © 1997 Jeffrey Jacobs & Associates
Last modified: June 17, 2003