You are currently browsing all posts tagged with datawindow

PowerBuilder – Refactoring Code to Reduce Database Calls

Posted on November 27, 2013 at 4:11 pm in

So I’m working on a fairly large enhancement to an application which is about twelve years old.  In a nutshell it involves allowing users to see data for multiple sites and multiple locations within each site.  Originally the app was created so the user could only view a single site at a time.  Which sites…

PowerBuilder – Refactoring Code to Reduce Database Calls - the full story »

Comment on PowerBuilder – Refactoring Code to Reduce Database Calls »

PowerBuilder ‘Gotcha’ – Tooltips do not display

Posted on April 1, 2013 at 5:17 pm in

I was working on setting up datawindow tooltips for a project and ran into an issue where sometimes they would not display for specific columns on the datawindow. Here is what you have to do: The tooltip Enabled property must be TRUE. The tooltip text must not be an empty string or NULL. The tooltip…

PowerBuilder ‘Gotcha’ – Tooltips do not display - the full story »

Comment on PowerBuilder ‘Gotcha’ – Tooltips do not display »

PowerBuilder – Datawindow Usability Improvements

Posted on December 27, 2012 at 5:25 pm in

I did a presentation at the 2012 PowerBuilder Developers Conference on improving the user experience in older PowerBuilder applications.  Later in December 2012 I presented an abstract of that on PowerBuilder TV.  The recorded session can be found here. I have updated the presentation files along with exports of the PB objects so that folks…

PowerBuilder – Datawindow Usability Improvements - the full story »

Comment on PowerBuilder – Datawindow Usability Improvements »

Datawindow Usability Improvements Presentation

Posted on December 4, 2012 at 7:49 am in

You can find the files from my PBTV presentation here.  I’ll do an in depth article later for those who could not attend the session. This is an extract from the session I presented at the SAP PowerBuilder Developers Conference 2012.

Datawindow Usability Improvements Presentation - the full story »

Comment on Datawindow Usability Improvements Presentation »

PowerBuilder – Update the Datawindow object definition programatically

Posted on October 11, 2012 at 6:31 pm in

I’m doing some work on an application to aid in the mass update of various datawindow attributes. It’s not rocket science since you are dealing with a series of text files and doing some basic ‘find and replace’ operations. However, if you have ever worked on a project which has been around for a while…

PowerBuilder – Update the Datawindow object definition programatically - the full story »

Comment on PowerBuilder – Update the Datawindow object definition programatically »

PowerBuilder ‘Gotcha’ – Column lists do not match

Posted on September 11, 2012 at 8:08 pm in

This is more of a database driver error but I encountered it within a datawindow I was working on so PB gets credit. I was working on a generic data drill down control which has a filtering process to eliminate data based on a date argument. Since I also wanted this date value for other…

PowerBuilder ‘Gotcha’ – Column lists do not match - the full story »

Comment on PowerBuilder ‘Gotcha’ – Column lists do not match »

PowerBuilder ‘Gotcha’ – Strings, Describe and Position Attributes

Posted on September 6, 2012 at 6:40 pm in

So I’m getting the position attributes of a column in a datawindow to aid in the display of another visual object. What I initially coded was this: ll_open_x = Long(adw.describe(as_colname + ‘.X’) + & adw.describe(as_colname + ‘.height’)) + 10 I run the window and my visual object is no where to be seen. Looking in…

PowerBuilder ‘Gotcha’ – Strings, Describe and Position Attributes - the full story »

Comment on PowerBuilder ‘Gotcha’ – Strings, Describe and Position Attributes »

PowerBuilder ‘Gotcha’ – Invalid Expression Error Message

Posted on August 31, 2012 at 6:58 pm in

So customer support calls regarding an issue a client is experiencing on a periodic basis. The receive an error ‘Invalid Expression’. To make things worse they get a series of these messages popping up and eventually the application crashes. Great. So we look at the datawindow object on the application window they are having issues…

PowerBuilder ‘Gotcha’ – Invalid Expression Error Message - the full story »

Comment on PowerBuilder ‘Gotcha’ – Invalid Expression Error Message »

PowerBuilder ‘Gotcha’ – SyntaxFromSql and System Fonts

Posted on July 12, 2012 at 5:56 pm in

So a user of an application I work on is getting an error when opening a window which contains a dynamic datawindow. The open process reads a table and then dynamically creates a grid datawindowobject with the same number of columns as the data which is retrieved from the table. The process itself uses the…

PowerBuilder ‘Gotcha’ – SyntaxFromSql and System Fonts - the full story »

Comment on PowerBuilder ‘Gotcha’ – SyntaxFromSql and System Fonts »

PowerBuilder ‘Gotcha’ – Grid Datawindows with Picture Controls

Posted on June 27, 2012 at 6:14 pm in

So I’m working on a ‘dashboard’ style datawindow in an application which shows a grid of data along with some graphics so the user can easily see changes/important stuff. There are a number of reasons to use a grid datawindow for this, especially since they can easily be changed by the user to suit their…

PowerBuilder ‘Gotcha’ – Grid Datawindows with Picture Controls - the full story »

2 Comments on PowerBuilder ‘Gotcha’ – Grid Datawindows with Picture Controls »

Top