Education » Advanced PowerBuilder Programming
Advanced Programming using PowerBuilder
(PB301) 5 Days
Lecture 60%/Labs 40%
Course Description
This course introduces students to advanced techniques used to develop fully-functional, well-performing business applications using PowerBuilder 9. This course teaches the development methodology required to build, debug, and deploy two-tier applications using advanced DataWindow techniques, user objects, and GUI controls.
Course Objectives
Upon Completion of the course you will be able to:
- Create standard, RichText, graphed, nested, crosstab, N-Up, newspaper column, and composite reports.
- Understand DataWindow and Dynamic DataWindow behavior, organization, and application.
- Use DataWindows and DataWindow techniques to generate XML and to access, update and validate data from the database.
- Create and Use DataWindows, DataStores, and other user objects.
- Write scripts to perform required processing.
- Access and Modify DataWindow object properties.
- Manipulate the properties and behavior of the DataWindow control.
- Manage transactions; concurrency; and database connections, access, and operations.
- Implement drag and drop for direct manipulation within an application.
- Use advanced graphical user interface (GUI) controls such as Tabs, ListViews, and TreeViews.
- Analyze issues involved in managing transactions and concurrency.
Who Should Attend
-
Developers and consultants with a solid understanding of PowerBuilder who are interested in learning more sophisticated client-server applications.
-
Application programmers who design and implement client/server applications using PowerBuilder.
-
Experienced PowerBuilder programmers.
Prerequisites
-
Experience developing PowerBuilder applications.
-
Basic PowerBuilder course or equivalent experience
-
Relational database and SQL experience
Cost & Scheduling Information
Group or individual pricing is available.
This course is available at our facilities or by arrangement.
Course Outline
- Advanced DataWindow Reporting
- Group Presentation Style
- Crosstab, N-Up, and Newspaper Column Reports
- PowerBuilder Reports
- Creating and Viewing PSR Files
- Advanced DataWindow Presentation
- Nesting Reports
- Graphs
- Rich Text Presentation Style
- Composite Reports
- DataWindow Behavior
- Data Validation
- Code Tables
- DataWindow Buffers
- Row and Column Status
- Dynamic DataWindow Behavior
- DataWindow Object Properties
- Conditional Property Expressions
- Dynamic DataWindow Creation
- Dynamically Changing a WHERE Clause
- Transaction Management
- Managing Database Connections
- Managing Concurrent Access
- DBMS Error Processing
- Managing Expensive Database Operations
- Advanced DataWindow Techniques
- External Data Source DataWindows
- DataWindow Button Controls
- Group Box Controls
- ShareData and ShareDataOff Functions
- User Objects
- Standard and Custom Visual User Objects
- Standard and Custom Class User Objects
- External Visual User Objects
- Advanced GUI Controls
- PictureListBoxes and Controls
- DropDownPictureListBoxes and Controls
- Tab Controls
- List View and Tree View Controls
- Drag and Drop Specifics
- Drag and Drop Functions and Guidelines
- Dragged Object Properties
- Target Object Events
