Contents

Title and Copyright Information

Contact Us!

Before You Begin

1 Introduction

What is Oracle AppWizard for Microsoft Visual C++?

Oracle Objects for OLE Overview

Installing Oracle AppWizard for Microsoft Visual C++

Basic Oracle AppWizard for Microsoft Visual C++ Concepts

Displaying Records

Single-Record Display Form

Multiple-Record Display Form

Master-Detail Display Form

Definitions

Microsoft Visual C++ 6.0 Limitations

2 Creating a Starter Application

Overview

Starting Oracle AppWizard for Microsoft Visual C++

Creating a Single- or Multiple-Record Display Application

Welcome Window

Connecting to an Oracle Database

Specifying the Type of Form

Selecting Tables and Columns

Specifying One or More Joins (Optional)

Specifying the Application Type and User Language

Completing the Remaining MFC Windows

Viewing the Application Classes

Viewing the Specifications for the New Application

Creating a Master-Detail Display Application

Specifying the Type of Form

Selecting Master Tables and Columns

Selecting Detail Tables and Columns

Building a Join Clause

Specifying the Application Type and User Language

Completing the Remaining MFC Windows

Viewing the Application Classes

Viewing the Specifications for the New Application

Building the Executable

Running the Executable

3 Understanding Your Application's Code

Introduction

Understanding the Generated Files

Source and Header Files

Precompiled Header Files

Resource Files

Miscellaneous Files

Understanding the Code Within Generated Files

Oracle Objects for OLE classes

What Happens When the Application Starts

Initializing Oracle Object for OLE C++ Class Library

Connecting to Database

Executing SQL Statements

Displaying Columns in a Table

Navigational Flow

How Record Navigation Works

Navigating to the First Record in the Database

Navigating to the Last Record

Navigating to the Previous Record

Navigating to the Next Record

Data Manipulation Flow

Adding a New Record

Updating a Record

Deleting a Record

Cancelling Changes to a Record

Generated Code for a Multiple-Record Display Form

4 Tutorial

Introduction

Before You Start

Lesson 1: Creating the Starter Application

Part 1: Working with Oracle AppWizard for Microsoft Visual C++

Starting the Oracle AppWizard for Microsoft Visual C++

Connecting to the Oracle Database

Naming and Specifying the Type of Form

Selecting Master Tables and Columns

Selecting Detail Tables and Columns

Building Join Clauses Between Tables

Specifying the Application Type and User Language

Completing the Remaining Steps

Part 2: Exploring Generated Classes and Files

Part 3: Viewing the ReadMe.txt for the Generated Project

Part 4: Building and Running the Application

Lesson 2: Adding Customer Information to a Purchase Order

Part 1: Creating a Dynaset Class for the Customer Table

Adding Member Variables to the COrderDynasetCustomer Class

Adding Member Functions and Implementation Details to the COrderDynasetCustomer Class

Part 2: Adding Customer Information to a Purchase Order

Part 3: Displaying Customer Information for a Purchase Order

Lesson 3: Enabling Users to Add Products to a Purchase Order

Part 1: Displaying a List of Items from the PRODUCT Table

Part 2: Adding the Selected Products to the Purchase Order

Lesson 4: Enabling Users to Update a Purchase Order

Part 1: Allowing the Detail Table Control to Handle Events

Part 2: Adding Implementation Details to the Event Handler Function

Lesson 5: Enabling Users to Add, Commit, or Cancel a New Purchase Order

Part 1: Creating a Customer List Dialog Box

Part 2: Creating a New Class to Handle Events for the Customer Dialog Box

Part 3: Creating"New Order", Commit Order", and"Cancel Order" Buttons

Part 4: Enabling Users to Add a New Purchase Order

Part 5: Enabling Users to Commit a New Purchase Order

Part 6: Enabling Users to Cancel a New Purchase Order

Index