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…
You are currently browsing all posts tagged with datawindow
PowerBuilder ‘Gotcha’ – SyntaxFromSql and System Fonts
PowerBuilder ‘Gotcha’ – Grid Datawindows with Picture Controls
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…
I should have known this would happen…
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…
PowerBuilder – Discarding Rows with Find
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 – Determining if Controls Overlap
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 – Fontheight method in Expressions
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 – More Datawindow Mouseover Effects
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 12.5 ‘Classic’ – New Feature
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 – Getting Database Identity Values after Multi Row Inserts from Datawindow
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 – Datawindow Drag/Drop Rows with Business Rules
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…