PowerBuilder Tips, Tricks, and Techniques

Arthur Hefti

Subscribe to Arthur Hefti: eMailAlertsEmail Alerts
Get Arthur Hefti via: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn

Top Stories by Arthur Hefti

So you think, "Why bother using PBDOM?" Well, you can use PDOM to manipulate elements in an XML document. That means you can move elements in a document or from one document to another. You can add elements to a document or delete them from a document. And, with a little coding, you can import nested XML data into a DataWindow. With the XML capabilities in the DataWindow introduced with Sybase's PowerBuilder 9, it's possible to import and export data very fast and easily. You might have glanced at the PBDOM definition in the PowerBuilder help and figured it looked hard to handle but, fear not, I'll introduce you to PBDOM and give you some code samples. Importing & Exporting with DataWindows Starting with PowerBuilder 9, the DataWindow can import and export data in XML. This powerful feature lets you exchange large amounts of data very fast. Importing and exporting i... (more)

The ClassDefinition Object

The ClassDefinition object was introduced in PowerBuilder 6.0 a long time ago. It allows you to retrieve information for an object at runtime. Most of us didn't pay too much attention to this object and it only attracts our attention when we see it in the debugger. In this article I provide an overview of the ClassDefinition object and related objects and explain the most important properties of these objects. I also include a step-by-step guide on how to build a simple object browser. This browser has a limited functionality like the browser included in the PowerBuilder runtime... (more)

PowerBuilder - The ClassDefinition Object

In the first article we presented a some theories about the ClassDefinition object and were able to show the libraries of a PB application in a treeview control. This month we'll read the objects from the libraries and inspect their content. When a user expands an entry in the treeview, we check to see if it was expanded once already. If it was, we don't take any action. We code this in the itemexpanding event of the treeview control, where we get the clicked treeviewitem by calling This.GetItem. If it wasn't expanded already, we check to see if the level of the treeviewitem is... (more)

Prognos with DataWindow.NET 2.0 and PowerBuilder 11 Web Services

Prognos is an application used over the Internet to determine if it makes sense to apply for a scholarship. It's part of a program package used in a couple of cantons (the equivalent of a state in the U.S.) in Switzerland to manage applications for a scholarship. The current version runs with DataWindow.NET 2.0 and uses PowerBuilder 11 Web Services. To keep the installation slim it uses no database; instead the data is stored in DataWindows or XML files. Prognos makes use of AJAX techniques and accesses .NET classes from PowerBuilder for XML handling. Since it's used in Switzerl... (more)

PowerBuilder .NET Web Services with Various Front Ends

Last year I wrote an article in PBDJ describing an ASP.NET project that was done with DataWindow.NET in the browser ("Prognos" Volume 14, Issue 4) and PowerBuilder Web Services in the back end. The front end consisted of an intro page, two data entry pages, and one page with the result. The front end was rewritten in a couple of other technologies to test different ways to create browser-based applications. This article covers solutions that run in different browsers and on different operation systems. I will also look at PowerBuilder 11.2 Webform although it is IE-only. At the ... (more)