You are currently browsing all posts tagged with datawindow

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 »

Comment on I should have known this would happen… »

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 »

Comment on Powerbuilder – Discarding Rows with Find »

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 »

Comment on PowerBuilder – Determining if Controls Overlap »

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 »

Comment on Powerbuilder – Fontheight method in Expressions »

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 »

Comment on Powerbuilder – More Datawindow Mouseover Effects »

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 »

Comment on Powerbuilder 12.5 ‘Classic’ – New Feature »

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 »

2 Comments on Powerbuilder – Getting Database Identity Values after Multi Row Inserts from Datawindow »

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 »

Comment on Powerbuilder – Datawindow Drag/Drop Rows with Business Rules »

Powerbuilder – Datawindow ‘SuperSpy’ tool

Posted on October 7, 2011 at 8:20 pm in

Not too long ago I came across some information on a free Powerbuilder tool call ‘DWSpy’ written by Michael Zuskin (you can find it here). In certain respects it is similar to my Window Object information service although geared towards datawindows. I decided to expand on the tool a bit by changing it into a…

Powerbuilder – Datawindow ‘SuperSpy’ tool - the full story »

Comment on Powerbuilder – Datawindow ‘SuperSpy’ tool »

Powerbuilder – Grid datawindow object with variable number of columns

Posted on August 17, 2011 at 8:20 pm in

Here is a way to build a grid datawindow which contains columns corresponding to an unknown number of data elements. You could use this approach in creating a project schedule, inventory location system, baseball box score, or any number of other examples. My example assumes the minimum number of columns to be four. This create…

Powerbuilder – Grid datawindow object with variable number of columns - the full story »

Comment on Powerbuilder – Grid datawindow object with variable number of columns »

Top