Welcome to the Appeon Community!

Learn, share knowledge, and get help.


Featured Blogs

Featured Articles

JSON Enhancements in PowerBuilder 2019


Support for the JSON format was added in the PowerBuilder 2017 R2 release and then enhanced in 2017 R3.  PowerBuilder 2019 contains even more enhancements in this area, particularly with regard to:

  1. Enhanced JSONParser
  2. Enhanced JSONPackage
  3. DataWindows Row Level Import/Export
  4. New ModelStore JSON Format


Read more

Two Factor Authentication using PowerBuilder

Two factor authentication is a way of increasing the security of an application by requiring the user to provide more than a simple password (one factor authentication).  Two factor authentication utilizes two of the following factors to identify the user:

1.  Knowledge - something you know - for example, your password

2.  Possession - something you have - for example, your cell phone or access to your email account

3.  Inherent - something you are - for example, fingerprints or eye iris

The third factor is out of scope for this particular article We're going to look at adding the second form (possession) to a PowerBuilder application. Specifically, we're What going to use Google Authenticator, an application for mobile devices (and the desktop) that generates time based one time temporary passwords (TOTP) for use with 2FA.

The sample code for this article is available on CodeXchange.


Read more

PowerBuilder 2019 New Feature: Applying a New UI Theme to Your Application

In PowerBuilder 2019, 3 new UI themes are provided to control how PowerBuilder’s commonly-used controls render in runtime applications. These new UI themes adopt a “Windows 10” style to enhance the appearances of applications. For detailed description of the themes, see Understanding system themes and Details on the theme settings and their effects.

You can directly control whether an application applies a new UI theme, or provide users with the ability to select a preferred theme by themselves. For details, see Applying a theme.

It is possible for you to modify a system theme through changing the theme template files, or to copy a system theme to create a custom theme. This way, you can further tune the color settings in the theme to your personal preference. For details, see Creating a custom theme.  

You may want to use the UI theme settings together with the PowerBuilder IDE settings and scripting techniques to achieve optimum UI effects. For samples on how to start the work, see Several useful techniques to further adjust your user interface.

Read more

Call SOAP Web Services Using HTTPClient Object

Since PowerBuilder 2017 R2, we have a new HTTPClient object, which is a base object for sending HTTP requests and receiving HTTP responses from a resource identified by a URI. Compared to the Inet object, the HTTPClient object is easier to use and supports more methods (Get/Post/Put/Delete) and more SSL protocols (TLS 1.0, TLS 1.1, TLS 1.2, SSL 2.0, and SSL 3.0).

Among other things, the HTTPClient can be also used to consume SOAP Web services. This is particularly useful as the Web Service Proxy has many limitations and defects calling SOAP Web services such as not supporting TLS 1.2. This article is to show how you can use the new HTTPClient to call your existing SOAP Web services instead. 

Read more

New Articles

Curso en Español de PowerBuilder


Hola Amigos, Comparto mi curso básico de PowerBuilder en Español. Los temas son los siguientes:

  • Introducción a PowerBuilder
  • Ambiente de desarrollo de PowerBuilder
  • Crear un objeto Aplicación
  • Creación de ventanas
  • Power Scripts
  • Bases de datos relacionales
  • Painter de Bases de datos
  • Objeto DataWindow
  • Conexión a Bases de datos
  • Programación orientada a objetos en PowerBuilder
  • Construyendo Menus
  • Introducción a aplicaciones MDI
  • Usando DataWindow Controls y MDI Sheets
  • Mostrando datos de la base de datos y declarando User Events
  • Conexión de DataWindows a Bases de datos
  • Declaración y uso de funciones en ventanas
  • Declaración y uso de eventos en ventanas
  • Creando instancias de ventanas
  • Declarando y usando Funciones
  • Modificando, Insertando, y borrando filas
  • Salvando cambios en la base de datos
  • Creación de Ejecutables
Read more

Inno Setup: Sample .ISS File

PowerBuilder v12.1, build 7055
Windows 7 32 bit platform
Windows 7 64 bit platform
Windows 10, 64 bit platform

A Sample Inno Setup ".ISS" File
Olan Knight

Once upon a time, long, long ago, we used a product called InstallShield to create the Windows installer for our various products. Over time, the cost for InstallShield became prohibitive, and we eventually settled on using Inno Setup as the replacement tool to create out installers.

You can get the free tool here:    http://www.jrsoftware.org/isinfo.php
The excellent HELP file is here:     http://www.jrsoftware.org/ishelp/   

It's a simple and intuitive tool, but it has some quirks and there is a learning curve. 
Inno Setup uses an ".iss" file as its source code. It compiles that ISS file into the SETUP.EXE for your application, with the file name being up to you.

Read more

Working with Branches in Git for PowerBuilder

One of the reasons that people choose to use Git is how easy it is to do branching. Unfortunately, PowerBuilder hasn't implemented it yet. But that doesn't stop you from using this feature if you don't mind taking a few extra steps. This article shows you how you can work on different branches with the help of TortoiseGit. 

Read more

Tips on Using Git with PowerBuilder

Many PowerBuilder developers want to try Git as it gains in popularity. However, as PowerBuilder IDE still relies on the binary PBL format instead of directly working with the plain text source code files, the implementation of native Git support comes with some special features that you may need to be aware of in order to use Git properly or to work around some of the limitations. This article tries to give some tips in this area.

Read more