Powerbuilder: Datawindow – what tier?

In continuation of my recent post about PowerBuilder – what tier, I would like to explore a little more on the technical front. In any books or articles on the power of PowerBuilder, you will always confront a Datawindow. A Datawindow is the heart of the GUI development in PowerBuilder. By design, a datawindow is […]

Rate this:

Powerbuilder and Source Code Control (SCC)

I posted about Source Code Control in general earlier. Various source code control software exist, named as Version Control Systems(VCS) or Source Control Systems (SCS) or even Source Code Control System (SCCS)*. If you noticed, these tools works at the file level – the smallest unit that can be handled in any Operating System. Typically, you […]

Rate this:

Gotcha: PB Deployment – SYSTEM var not supported error

When you work on code deployed to n-tier, you have to be little more careful while defining the interface for the objects. An n-tier application typically runs in an heterogeneous environment, meaning objects in different languages/platforms may talk to each other through a common interface. If you are not careful, your object may end up […]

Rate this:

PB Gotcha – Embedded (inline) SQL – SELECT..INTO

Just a quick gotcha I stumbled on in PB code. This is about SELECT..INTO. As you know, SELECT..INTO expects one row and it works well as long as there is only one row.While researching another issue, I saw the below SQL in one of the objects in our application. of_get_cutoffdate ….  // Date ld_CutOff…. SELECT […]

Rate this:

Script: PB backup – Using PB ORCA to export PBLs

A basic Operating system level unit in Powerbuilder is a library file (.PBL). Each PBL file is a self contained directory in itself, with the objects stored inside in a proprietary binary format. You need Powerbuilder to view and work with this directory structure (System tree, Library painter etc). Sometimes, it would be nice to be […]

Rate this: