Welcome!

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)

SPBUG Meeting: Refactoring of PB applications based Test Driven Development

On Wednesday December 15th, 2010 SPBUG presents a seminar with Yakov Werde: Refactoring of PowerBuilder applications based Test Driven DevelopmentYakov Werde, a 25 year IT industry veteran, has been designing and delivering PowerBuilder training for over 14 years, more than ten of them as an employee of Sybase Inc. Before that he worked as an application architect, project manager and application coder in the trenches of application software development. A professional technology educator, Yakov holds a Masters in Education with a specialty in instructional design for online lear... (more)

Encryption in PowerBuilder

Keeping information away from curious eyes is a challenging task. For example, you might need to encrypt data before sending it over the Internet. Or you might be storing some information in a database that not even an administrator is allowed to see. This article provides a brief overview of encryption techniques and shows how to do encryption in PowerBuilder. Short History Encryption goes as far back as ancient Egypt. In 1900 B.C. the Egyptians used a derivation of standard hieroglyphics to make a message more difficult to read. The art of hiding messages improved over the centu... (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 - 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)