You are currently browsing the PowerBuilder category

I’m Back…

Posted on March 11, 2021 at 5:03 pm in

This blog has been brought out of it’s coma. More PowerBuilder, sql, and programming content to be forthcoming. Will be re-starting my PowerBuilder Tutorial Series, “100 days of PowerBuilder” with the more current Appeon 2019 versions. Old visitors may notice that comments are no longer being accepted for any articles. This is due to privacy…

I’m Back… - the full story »

PowerBuilder – SQL Native Client Transaction Persistance

Posted on December 17, 2013 at 10:08 am in

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 – SQL Native Client Transaction Persistance - the full story »

PowerBuilder – Refactoring Code to Reduce Database Calls

Posted on November 27, 2013 at 4:11 pm in

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…

PowerBuilder – Refactoring Code to Reduce Database Calls - the full story »

Comment on PowerBuilder – Refactoring Code to Reduce Database Calls »

PowerBuilder – Failed to get the service list

Posted on April 4, 2013 at 6:49 pm in

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 – Failed to get the service list - the full story »

PowerBuilder ‘Gotcha’ – Tooltips do not display

Posted on April 1, 2013 at 5:17 pm in

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…

PowerBuilder ‘Gotcha’ – Tooltips do not display - the full story »

Windows 7 ‘Gotcha’ – PowerBuilder Application Control Fonts Too Large

Posted on February 21, 2013 at 7:17 am in

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…

Windows 7 ‘Gotcha’ – PowerBuilder Application Control Fonts Too Large - the full story »

PowerBuilder – Writing to the Windows Event Log

Posted on February 13, 2013 at 5:32 pm in

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 – Writing to the Windows Event Log - the full story »

PowerBuilder – Datawindow Usability Improvements

Posted on December 27, 2012 at 5:25 pm in

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…

PowerBuilder – Datawindow Usability Improvements - the full story »

Datawindow Usability Improvements Presentation

Posted on December 4, 2012 at 7:49 am in

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.

Datawindow Usability Improvements Presentation - the full story »

Getting your COM component Registered for use with PowerBuilder

Posted on November 5, 2012 at 7:29 pm in

I built a COM component to allow for the taking of pictures from a webcam in PowerBuilder. The component itself was done in Visual Studio 2010 in C# and makes use of a web camera control created to use the Directshow API library available as part of the Windows SDK. You can find more information…

Getting your COM component Registered for use with PowerBuilder - the full story »

Top