PowerBuilder Training Overview
This course introduces students to advanced techniques used to develop fully functional, well performing business applications using PowerBuilder 11. Upon successful completion of this course, the student should be able to:
- Create standard reports, including TreeViews, graphs, crosstabs, and multi-group 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 and PDF files.
- Create and use standard, custom, and external user objects.
- Implement advanced elements of the graphical user interface, such as MonthCalendar, Animation, 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 11.
Powerbuilder Training Prerequisites
- Basic PowerBuilder 11 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
Advanced DataWindow Presentation Styles |
|
Group Presentation Style·
TreeView Presentation Style
Crosstab Presentation Style
N-Up Presentation Style
Newspaper Column Reports
Graph Presentation Style
Rich Text Presentation Style
|
DataWindow Reporting
|
|
Printing-Related Functions
Generating PDF and PSR Files
Composite Reports
Nesting DataWindows
|
Understanding DataWindow Behavior |
|
Data Validation Process
Data Validation Techniques
Required DataWindow Columns
DataWindow Buffer Processing
Managing Row/Column Status
|
Dynamic DataWindow Behavior |
|
Conditional Property Expressions
Accessing DataWindow Object Properties
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
|
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 |
|
PictureListBox and DropDownPictureListBox Controls
MonthCalendar and DatePicker Controls
Animation Controls
Tab Controls
ListView Controls
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) |
|
Additional Scripting Topics
Transaction Management
Testing Techniques
Using Data Pipelines
Dynamic SQL
|
|