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

Für die Kulturförderung des Kantons Bern habe wir eine Webanwendung zur Abfrage der Liste der Lebendigen Traditionen realisiert, welche über http://www.erz.be.ch/lebendigetraditionen direkt aufgerufen werden kann. Diese Projekt wurde im Rahmen der Umsetzung der 2008 für die Schweiz in Kraft getretene UNESCO-Konvention zur Bewahrung des immateriellen Kulturerbes (lebendige Traditionen) realisiert. Die Anwendung basiert auf ASP.NET und ist in das CMS des Kantons Bern integriert. Sie wird über einen WebService mit Daten aus der internen Anwendung versorgt, welche im Intranet der Erziehungsdirektion des Kantons Bern läuft. Diese Daten werden direkt auf einem SQL Server 2008 aufbereitet und an den Empfangs-WebService gesandt. Hier noch die offizielle Pressemitteilung der Erziehungsdirektion des Kantons Bern. ... (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)

Using PowerBuilder Assemblies in .NET

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 S... (more)

Using MS MapPoint in PowerBuilder

Why should you use GIS (Geographic Information System) data in PowerBuilder? You can plan a route for a service technician or a sales person. You can track the positions of the trucks delivering goods and it might allow you to direct a truck to an additional pick up close to its route. You can print driving directions when heading to an unknown place. The following article demonstrates how to use the Microsoft MapPoint control from within PowerBuilder to perform such operations. The MapPoint Control The MapPoint object model contains a lot of objects, but we'll use only a few. Fi... (more)