PowerBuilder Training Overview
This course introduces students to advanced techniques used to develop fully functional, well performing business applications using PowerBuilder 9. 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.
- Use DataWindows to generate XML.
- 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 the PowerBuilder Native Interface with 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 9.
PowerBuilder Training Prerequisites
- Basic PowerBuilder 9 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
Printing-Related Functions
Generating PDF and PSR Files
Composite Reports
Nesting DataWindows
|
|
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
DataWindow Support for XML
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
|
|
Exception Handling in PowerBuilder |
| |
Objects for Exception Handling
TRY-CATCH Structure
Creating User-Defined Exception Types
THROW Statement
Throwing Exceptions From Functions
|
|
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
|
|
Supplemental Topics (as time permits) |
| |
Advanced DataWindow Presentation Styles
Crosstab Presentation Style
N-Up Presentation Style
Newspaper Column Reports
Creating Graphs
Rich Text Presentation Style
Additional Scripting Topics
Registry Processing
INI File Processing
Using the Environment Object
Using External Functions
Testing Techniques
Using Data Pipelines
Dynamic SQL
|
|
