Not too long ago I came across some information on a free Powerbuilder tool call ‘DWSpy’ written by Michael Zuskin (site is gone now apparently). 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…
You are currently browsing all posts tagged with datawindow
PowerBuilder – Datawindow ‘SuperSpy’ tool
PowerBuilder – Grid datawindow object with variable number of columns
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 ‘Gotcha’ – Datawindow Column Alignments
I’ve been working quite a bit lately on the ‘tooltip’ type of functionality for datawindows. I encountered an issue today which gave me a bit of hassle until I worked it out. My technique looks at the width of the column and it’s position within the datawindow control to decide whether or not all the…
PowerBuilder – Type ahead style dropdown datawindow columns
This type of functionality is one of those things which fills a gap so completely and perfectly that when you encounter some application (and almost all web pages) which doesn’t have it you groan to yourself. In the ancient past this was alternatively referred to as ‘Quicken style’ dropdowns since that application was one very…
PowerBuilder ‘Gotcha’ – Modify Parent Datawindow after a Getchild
If your window makes use of a datawindowchild for whatever reason remember that if you modify the parent datawindow the reference to the child will (most likely) be lost. In the PB Help it states: If a property causes this behavior, this is noted in its description in Chapter 3, “DataWindow Object Properties.” but I…
PowerBuilder – Treeview like Tooltips for Datawindows
The treeview control has a very neat piece of functionality built in called Tooltips. When this property is checked your application will automatically display all the text on a treeview item if it is cut off by the edge of the control when the mouse pointer goes over that row. If the row text is…
PowerBuilder – Datawindow column Edit.Style values
checkbox dddw ddlb edit editmask inkedit radiobuttons richtext For some reason I couldn’t find this information in a nice list so here it is.
PowerBuilder ‘Gotcha’ – Removing Blank Rows from Datawindow
I’m working with a ‘pre-Cambrian’ framework of sorts which has a datawindow ancestor with quite a lot of functionality in it. One standard piece in list type datawindows is to insert a blank row when the user opens a window. This way the user doesn’t have to click a ‘new’ button or do something else…
PowerBuilder – Setting column value without looping through all rows.
A question came up on the TekTips website about setting a column in all the rows in a datawindow to the same value without looping through. In this case the writer was loading data from over one hundred Excel files and wanted to track the filename of where the data came from. At first I…
PowerBuilder – Move Frequently Chosen Items to Top of DropDownDataWindow
I’m looking at an application which basically records demographic information for a population. One of the fields listed is ‘primary language’ which has a typical dropdowndatawindow interface. I look at the options and BAM!, a huge alphabetical list (including Esperanto!). Now this application is generally used in the US so my guess is at least…