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

PBDJ Feature Story There's a lot of "legacy" PowerBuilder code that you might want to access from .NET applications or perhaps PowerBuilder has some superior functionality that you would like to make use of in a .NET application. Think about how easy it would be to create a report in PowerBuilder with a DataWindow. Of course, PB can provide functionality through Web Services (see my article "Prognos with DataWindow.NET 2.0 and PowerBuilder 11 Web Services" in PBDJ some time ago) but this has its limitations. In the article "PowerBuilder 11's .NET Interoperability" in PBDJ, John Strano showed briefly how to use a PowerBuilder assembly in .NET. This article demonstates how to create a PowerBuilder assembly and elaborates on how to reuse this assembly in C# projects. First, I will start with a simple console application, then go over to an ASP.NET page and finish with ... (more)

CATTOR Mobile: Papierlose Servicerapporte inkl. Unterschrift

Zürich, 3. Januar 2014 – Per sofort ist die Version 2.0 von CATTOR Mobile im iTunes App Store verfügbar. Wichtigste Neuerungen, neben der Anpassung an iOS 7, ist der „Nur Stunden“ Modus für Aufträge. Ist ein Auftrag mit „Nur Stunden“ markiert, so sieht der Kunde nur aufgewendete Stunde und keine Preise auf den Ersatzteilen. In-House Aufträge sind nun auch prominenter markiert. CATTOR Mobile ist eine iPad Anwendung für den Servicetechniker, auf die eingeplante Aufträge synchronisiert werden. Der Servicetechniker fügt die aufgewendeten Zeiten dem Auftrag hinzu und erfasst noch Beme... (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)