PowerBuilder Training Overview
This course introduces students to advanced techniques used to develop fully functional, well performing business applications using PowerBuilder 7. Upon successful completion of this course, the student should be able to:
- Create standard reports, including graphs, crosstabs, and multi-column reports.
- Create RichText, nested, and composite style reports.
- Manipulate the properties and behavior of the DataWindow control.
- Access and modify the properties of the DataWindow object.
- Describe the internal organization of the DataWindow buffers.
- Analyze issues involved in managing transactions and concurrency.
- Use DataWindow techniques to access, update, and validate data from the database.
- Create a DataWindow dynamically.
- Create and use DataStores.
- Create and use standard, custom, and external user objects.
- Implement advanced elements of the graphical user interface, such as ListView, TreeView, and Tab controls.
- Use drag and drop for direct manipulation within the application.
- Use external functions in PowerBuilder applications.
- Use a variety of techniques to test, debug, and analyze PowerBuilder applications.
A series of written and lab exercises will be used to reinforce the classroom education.
PowerBuilder Training Audience
Application programmers responsible for the design and implementation of client/server applications using PowerBuilder 7.
PowerBuilder Training Prerequisites
- Basic PowerBuilder 7 Programming or an equivalent class.
- Four to six weeks experience developing PowerBuilder applications.
This course teaches sophisticated concepts at an accelerated pace. Students new to PowerBuilder are encouraged to complete the prerequisite course before taking this course.
PowerBuilder Training Course Duration
5 Days
Powerbuilder Training Course Outline
|
DataWindow Reporting |
| |
Group Presentation Style
Crosstab Presentation Style
N-Up Presentation Style
Newspaper Column Reports
PSR Files
|
|
Advanced DataWindow Presentation Styles
|
| |
Composite Reports
Nesting DataWindows
Creating Graphs
Rich Text Presentation Style
|
|
Understanding DataWindow Behavior |
| |
Data Validation Process
Data Validation Techniques
Using Code Tables
Using DropDownDataWindows
Required DataWindow Columns
DataWindow Buffer Processing
Managing Row/Column Status
|
|
Transaction Management |
| |
Managing Database Connections
Managing Concurrent Access
Handling Database and DataWindow Errors
Multiple Row Updates
Managing Potentially Expensive Database Operations
|
|
Dynamic DataWindow Behavior
|
| |
Conditional Property Expressions
Accessing DataWindow Object Properties
Property Expressions
Describe and Modify Functions
Dynamically Changing a WHERE Clause
Dynamic DataWindow Creation
|
|
Advanced DataWindow Techniques
|
| |
Using an External Data Source
Using a Stored Procedure Data Source
Creating and Using DataStores
Sharing a Result Set
Coordinating Updates
|
|
User Objects
|
| |
Standard Visual User Objects
Custom Visual User Objects
Standard Class User Objects
Custom Class User Objects
External User Objects
|
|
Advanced GUI Controls
|
| |
Implementing PictureListBox and DropDownPictureListBox Controls
Implementing Tab Controls
Implementing ListView Controls
Implementing TreeView Controls
|
|
Using Drag and Drop in Applications
|
| |
What Is Drag and Drop?
Draggable Object Properties
Automatic Drag vs. Manual Drag
Drag and Drop Guidelines
|
|
Using the Data Pipeline
|
| |
Overview
Data Pipeline Painter
Using Pipeline Objects in Applications
|
|
Supplemental Topics
|
| |
Testing DataWindows
Testing Applications
Using External Functions
Dynamic SQL
|
|
