Powerbuilder Webinars

Implementing Datawindow Usability Improvements with Minimal Disruption

Tuesday, Decembre 4th, 2012
9:00am PST (Los Angeles)/18H00 CET (Paris)

This presentation covers techniques to create and implement a 'datawindow enhancement service' within an existing PowerBuilder application with the goal of providing improved functionality while keeping disruption to application users to a minimum. It is similar to the session presented at the 2012 PowerBuilder Developers Conference held in October in conjunction with SAP TechEd. Focus for this session will be on the creation of the service object, implementing example functionality enhancements with existing datawindows, and ideas for further expansion of the service.

Presenter: Matt Balent

Download the files for the presentation on Matt Balent's blog The Anvil of Time


Click here to see the recorded webinar


Gantt Chart Planner — Consuming .NET Assemblies in PowerBuilder .NET

Tuesday, November 27th, 2012
9:00am PST (Los Angeles)/18H00 CET (Paris)

Construction companies need an overview of their planning and work in progress. HBBSoft, a PowerBuilder .NET application, aims to achieve this purpose using Gantt and scheduling. The application is able to communicate with the Microsoft Exchange Calendar using Microsoft Exchange Web Services (EWS) to plan employees’ tasks immediately into the Outlook calendar. This presentation covers several techniques used in the HBBSoft application:
• .NET user authentication.
• Consuming Exchange Web Services to sync with Exchange Calendar.
• Custom Expression Blend toolbar.
• Integration of third-party Gantt and schedule controls.

Presenter: Dimitri Joosten


Click here to see the recorded webinar


How to Migrate 7000 Objects in 180 PBLs from PowerBuilder Classic to PowerBuilder .NET

Tuesday, November 20th, 2012
9:00am PST (Los Angeles)/18H00 CET (Paris)

This session presents Turkcell’s project experiences, and discusses the migration process in technical detail. As of 2011, Turkcell — with its 64.8 million subscribers — is not only the leading telecommunications operator in Turkey, but also the third-largest GSM operator in Europe in terms of subscriber number. The company’s development team has been using PowerBuilder for more than 10 years, beginning with version 6.5 and currently is using version 12.5. Turkcell’s enterprise telecommunications application NEMS consists of 180 PBLs and more than 7000 objects that work with SAP Sybase ASE in more than 2000 tables as a native Windows application. There are 16 different modules under NEMS. Recently, Turkcell began an effort to migrate from PowerBuilder Classic to PowerBuilder .NET. Within this project, NEMS will be split into different targets creating separate native Windows applications for easy maintenance which then will be migrated to .NET. As an application of 180 PBLs, it is a difficult process to find and split the independent objects from others while considering base objects — such as PFC objects from which all DataWindows and Windows are inherited — and also common objects such as global functions. So far, Turkcell has migrated four of the 16 modules.

Presenter: Sonat Karakas

Click here to see the recorded webinar


You asked, he answered!

Find below the questions and answers from Bruce Armstrong's (originally done by Oscar Tobar) presentation on Best practices for managing exceptions and errors in PowerBuilder.

Are there any performance benefits to using this?

Aren't you still going to end up with just as much code, just in a somewhat different order? (In fact, more code, because you have all those extra objects, e.g. your custom exceptions.) 

Actually, RuntimeError has a lot more Properties than Throwable, so wouldn't it be better to inherit from it?

How can I control some VM errors from code ? 


Find other Questions and their answers on PowerBuilderTV

Creating and Consuming Web Services Based on SQL Queries in PowerBuilder

Tuesday, October 30, 2012
10:00am PST (Los Angeles) / 18:00 CET (Paris)

Unlike direct connections to the database, Web services can be managed and secured outside of an application and used by any Website or client/server, Web, or mobile application. An SAP Sybase PowerBuilder application then can use Web services to return data sets as data sources of the application’s DataWindows. This facilitates the incorporation of PowerBuilder applications and Web services into a cloud computing environment. This session explains and demonstrates how to:

• Build a data store based on a chosen query and structure that can be used for constructing Web service output.
• Create a class (NVO) as a wrapper of a Web service with the necessary “Get_...()” functions that populate arrays of structures from respective data store(s).
• Deploy a created Web service to an IIS Web server including the creation of a WSDL file.
• Create a DataWindow with a Web service as a data source.
• Choose a proper Web service and find its desired method (“Get_...()” function).
• Select a proper parameter from the chosen Web service method and finalize the created DataWindow to solve hidden problems with the string data type.

Presenter: George Mikhailovsky

Find the code for the presentation here.

Click here to see the recorded webinar