Course announcements

  • Get started with PowerBuilder development by building and deploying a complete two- tier client/server application.

Goals

  • Use the PowerBuilder IDE to create workspaces, targets and fully functional applications
  • Planning and designing PowerBuilder Library Structure (PBL)
  • Define the Application Object for a new target, defining application initialization and cleanup code
  • Explain the Event Driven programming
  • Create local variables, global variables and global functions
  • Define connections to backend databases
  • Create Objects containing object-level functions, external functions, mapped and unmapped events, instance and shared variables
  • Write code
  • Create Tabular, Grid and FreeForm DataWindows, Windows, User Objects, Menus and Toolbars
  • Use object-oriented techniques to build a framework of Windows, Controls and commonly used PowerBuilder Non-Visual Objects (NVOs)
  • Sort, Filter, Export and Print from the DataWindow
  • Partition an application by separating business rules from the user interface, and code the logic for these rules in PowerBuilder (NVOs)
  • Deploy of completed application to the end users

Audience

  • Developer
  • Development Consultant

Prerequisites

Essential

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

Recommended

  • Knowledge of SQL.

Course based on software release

  • PowerBuilder (Classic IDE) 12.5.1

Content

  • Connected Workspaces
    • Setting Up Workspaces, Targets, and Application Objects
    • Connecting to a Data Source Using Database Profiles
  • 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
  • Windows and Window Controls in SAP PowerBuilder
    • Creating and Using a Framework
    • Modifying Framework Windows
    • Creating and Using Standard Visual Objects
    • Using Configuration Files
  • Menus in SAP PowerBuilder
    • Creating a Menu Hierarchy
    • Writing Code for Common Menu Items
  • Multiple Document Interface (MDI) Applications
    • Building Application Windows
    • Opening Windows and Resizing Controls
  • Display of Data from the Application Database
    • Using the Application Database
    • Creating DataWindow Objects and Managing Extended Attributes
  • DataWindow Object Creation
    • Using the SQL Select DataSource
    • Modifying the Presentation of the Result Set
  • DataWindow Controls
    • Writing Basic Database Connection and Disconnection Logic
    • Completing Application Sheets
  • Updates to the Database Using DataWindows
    • Inserting and Deleting Data
    • Saving Data to the Database
  • Non-Visual User Objects
    • Creating Custom Class User Objects
    • Creating Standard Class User Objects
  • Message Object Communications
    • Communicating Between Objects
    • Passing NVOs to Message Objects
  • PowerBuilder Application Deployment
    • Deploying an Application
  • Advanced DataWindow Functionality
    • Enabling DataWindow Functionality
    • Implementing a Master-Detail Interface
    • Implementing Client-Side Sort and Filter
    • Implementing Data Validation
    • Completing Update Functionality