An annoyance in a PB window with a datawindow control on it is if you back tab to the dw, your cursor is positioned to the first field and not the last field. The following technique can eliminate that and make your application a bit more user friendly. In the Getfocus event of the datawindow:…
You are currently browsing all posts tagged with Powerbuilder
PowerBuilder – Back Tab to Last Field in DataWindow
Comment on PowerBuilder – Back Tab to Last Field in DataWindow »
PowerBuilder – Getting the Display Value from a Drop Down DataWindow
This is very basic functionality but easily forgotten. Say you have a datawindow built from the ‘part’ table and a column for partType is a DDDW. You want the description of the partType code (which is displayed in the row showing the parts). To do this you use the evaluate method with the describe method…
Comment on PowerBuilder – Getting the Display Value from a Drop Down DataWindow »
PowerBuilder – SQL Native Client Transaction Persistance
There can be an issue with transactions not being disconnected from SQL Server when using the SQL Native Driver (SQLNCLIxx driver). In my case when the application was closed, the transactions were held open for up to four minutes. This may not be an issue with a small number of connections but with a large…
PowerBuilder – Refactoring Code to Reduce Database Calls
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…
Comment on PowerBuilder – Refactoring Code to Reduce Database Calls »
PowerBuilder – Failed to get the service list
Just so this is documented and maybe come up on a search sometime, here is an error message fail: I got this attempting to set up a new .Net Web Service proxy in PB Classic.
PowerBuilder ‘Gotcha’ – Tooltips do not display
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…
Windows 7 ‘Gotcha’ – PowerBuilder Application Control Fonts Too Large
So I finally got my computer upgraded to Windows 7 at work. I was very happy to have it since XP was really starting to annoy me and I couldn’t really do some of the development tasks I needed to get done. After a week or so I started looking through the applications I work…
PowerBuilder – Writing to the Windows Event Log
Here are two ways to write to the Event log in Windows and indicate the source of the message. Reportevent External Function and Eventcreate command line command You can use the command shell to do this too but this has the drawback of not being able to assign the source of the event. First you need…
PowerBuilder – Datawindow Usability Improvements
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…
Datawindow Usability Improvements Presentation
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.