You are currently browsing all posts tagged with datawindow

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 »

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 »

I should have known this would happen…

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

So I’m encountering an issue in PowerBuilder where I’m creating a datawindow object from a dynamically built SQL statement and a user is getting some wonky results along with a cryptic “datawindow release number is incorrect” message. A quick Google and then… Fine time for a single search hit…

I should have known this would happen… - the full story »

PowerBuilder – Discarding Rows with Find

Posted on May 10, 2012 at 5:37 pm in

It’s a fairly common practice to report on a set of data derived from a larger group of rows. There are many techniques to do this in code and with the methods available with datawindows/datastores. One typical approach is to use the Filter method. The problem with this is it requires another trip to the…

PowerBuilder – Discarding Rows with Find - the full story »

PowerBuilder – Determining if Controls Overlap

Posted on May 2, 2012 at 5:32 pm in

I had a situation where I needed to know if the user is clicking on a control which is underneath a rectangle on a datawindow. In this case the interior of the rectangle was transparent. ls_name = dwo.name IF (left(ls_name, 2) = 'r_') THEN // my standard rectangle naming convention ls_objects = this.Describe( 'DataWindow.Objects') ls_objects…

PowerBuilder – Determining if Controls Overlap - the full story »

PowerBuilder – Fontheight method in Expressions

Posted on February 29, 2012 at 2:29 am in

An enhancement was put into PB12.1 dealing with determining the height of a datawindow column based on its font setting. It’s called Fontheight and takes a string parameter. Unfortunately there does not appear to be any documentation on it in the PB help files (I’m looking in PB12.5). You can see a reference to it…

PowerBuilder – Fontheight method in Expressions - the full story »

PowerBuilder – More Datawindow Mouseover Effects

Posted on February 9, 2012 at 8:24 pm in

So I download the latest Chrome browser beta the other day (v17) and I notice a neat effect on the tabs prior to applying my custom settings. A gradient centered on my mouse pointer passed across the tab as I moved it. It was very subtile but noticiable if you were paying attention. Naturally I…

PowerBuilder – More Datawindow Mouseover Effects - the full story »

PowerBuilder 12.5 ‘Classic’ – New Feature

Posted on February 7, 2012 at 6:56 pm in

I just stumbled on a neat new feature in the datawindow painter, specifically on the background tab of a column. The Gradient stuff was added in 10.5 (I believe) and now you can actually see the numeric value of the slider bar without having to pick through the source. Refer to the following: All of…

PowerBuilder 12.5 ‘Classic’ – New Feature - the full story »

PowerBuilder – Getting Database Identity Values after Multi Row Inserts from Datawindow

Posted on December 22, 2011 at 7:40 pm in

This is a technique to use when you have a data entry window in which multiple parent records can be inserted along with multiple child records for each parent and your tables have their record keys set up as identity values. The database in question for this discussion is SQL Server. This figure shows a…

PowerBuilder – Getting Database Identity Values after Multi Row Inserts from Datawindow - the full story »

PowerBuilder – Datawindow Drag/Drop Rows with Business Rules

Posted on December 21, 2011 at 12:40 pm in

This time I’m demonstrating a basic bit of functionality common to many Windows based applications – drag and drop. In this case I am talking about the ability to drag a row of data to a new location in a list. However, to make it more interesting I am throwing in some business rules which…

PowerBuilder – Datawindow Drag/Drop Rows with Business Rules - the full story »

Top