PowerBuilder 9.0 Basic Course

Upon completion of this course, the student will be able to:
> Use the System Tree create workspaces and targets
> Use the Application Painter to create application objects
> Use the Window Painter to create windows
> Use the PowerScript language to write scripts to perform required processing
> Create user functions and user events
> Use the Menu Painter to design menus and connect them to windows
> Use the Database Painter to define extended attributes and manage database tables
> Use the Query Painter to interactively construct and edit SQL statements
> Use the DataWindow Painter to create Data Windows and select appropriate presentation styles and data sources
> Design and test PowerBuilder reports
> Debug PowerBuilder applications
> Package a PowerBuilder application for distribution

Introduction
Role of PowerBuilder in Application Development
PowerBuilder Application Architectures
Platforms and Databases Supported by PowerBuilder
PowerBuilder Concepts and Terminology
Versions of PowerBuilder
PowerBuilder Resource Requirements

The PowerBuilder Environment
Painter Structure
Customizing Toolbars
The System Tree
The Clip Window
Managing Painter Views and Panes
Object Browser

Creating an Application
Creating Workspaces
Creating Targets
Creating Application Objects
Application Object Properties

Creating Windows
Types of Windows and Controls
Building Windows
Window Inheritance

PowerBuilder Scripts
Language Syntax
Assignments and Property Modification
Using the PowerScript Painter
Control Structures
PowerScript Functions
Script Inheritance

Creating DataWindows
Presentation Styles
Data Sources
DataWindow SQL Options
Customizing the DataWindow Design

Managing Database Tables
Maintaining Database Profiles
Creating Extended Attributes
Manipulating Table Data

Implementing DataWindows
Associating a DataWindow Object with a DataWindow Control
Transaction Objects
DataWindow Functions

DataWindow Updates
Controlling Updates
Data Validation Process
Transaction Management

Creating Menus
Creating Menu Bars and Menuitems
Menu Events and Scripts
Popup Menus
Menu Inheritance

MDI Applications
MDI Terminology
MDI Window Types
MDI?Related PowerScript Functions
MDI Menus and Toolbars

Distributing the Application
Creating an Application Executable
PowerBuilder Resource Files
PowerBuilder Dynamic Libraries
Creating a Machine Code Executable

Supplemental Topics (as time permits)
User-Defined Function and Events
Exception Handling
Library Painter
Debug Painter
Structures

> Basic knowledge of the Windows operating system
> Introduction to SQL or equivalent experience
> Experience in a programming language, such as COBOL, PASCAL, or BASIC