Description
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.
Audience
Application programmers responsible for the design and implementation
of client/server applications using PowerBuilder 7.
Prerequisites
Basic PowerBuilder 7 Programming (100-077), 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.
Course Agenda
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
