Introduction

SAP Sybase PowerBuilder is the most productive tool for building data driven business applications. Its patented DataWindow technology is still the fastest and most efficient way to rapidly access complex data sets, apply business logic, and display data with just a few lines of script. The PowerBuilder space is the place to find customer references, technical docs, best practices, and links to the developer community.

Prerequisties

• Developer experience in any language.
• Basic knowledge or relational databases.
• Knowledge of SQL

Course Content

1. Connected Workspaces

• Setting Up Workspaces, Targets, and Application Objects
• Connecting to a Data Source Using Database Profiles

2.PowerBuilder Code

• Employing Basic Programming Techniques
• Writing Code Using Basic Coding Techniques
• Creating and Invoking Methods
• Creating Global Functions
• Using Enumerated Data Types
• Creating Global Variables and Defining External Functions
• Debugging an Application

3. Windows and Window Controls in SAP PowerBuilder

• Creating and Using a Framework
• Modifying Framework Windows
• Creating and Using Standard Visual Objects
• Using Configuration Files

4. Menus in SAP PowerBuilder

• Creating a Menu Hierarchy
• Writing Code for Common Menu Items

5. Multiple Document Interface (MDI) Applications

• Building Application Windows
• Opening Windows and Resizing Controls

6. Display of Data from the Application Database

• Using the Application Database
• Creating Data Window Objects and Managing Extended Attributes

7. Data Window Object Creation

• Using the SQL Select Data Source
• Modifying the Presentation of the Result Set

8. Data Window Controls

• Writing Basic Database Connection and Disconnection Logic
• Completing Application Sheets

9. Updates to the Database Using DataWindows

• Inserting and Deleting Data
• Saving Data to the Database

10. Non-Visual User Objects

• Creating Custom Class User Objects
• Creating Standard Class User Objects

11. Message Object Communications

• Communicating Between Objects
• Passing NVOs to Message Objects

12. PowerBuilder Application Deployment

• Deploying an Application

13. Advanced Data Window Functionality

• Enabling DataWindow Functionality
• Implementing a Master-Detail Interface
• Implementing Client-Side Sort and Filter
• Implementing Data Validation
• Completing Update Functionality