You are currently browsing all posts tagged with programming

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 – 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 »

Comment on PowerBuilder – Writing to the Windows Event Log »

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 »

Comment on PowerBuilder – Datawindow Usability Improvements »

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 »

Comment on Datawindow Usability Improvements Presentation »

PowerBuilder – Update the Datawindow object definition programatically

Posted on October 11, 2012 at 6:31 pm in

I’m doing some work on an application to aid in the mass update of various datawindow attributes. It’s not rocket science since you are dealing with a series of text files and doing some basic ‘find and replace’ operations. However, if you have ever worked on a project which has been around for a while…

PowerBuilder – Update the Datawindow object definition programatically - the full story »

Comment on PowerBuilder – Update the Datawindow object definition programatically »

PowerBuilder ‘Gotcha’ – Column lists do not match

Posted on September 11, 2012 at 8:08 pm in

This is more of a database driver error but I encountered it within a datawindow I was working on so PB gets credit. I was working on a generic data drill down control which has a filtering process to eliminate data based on a date argument. Since I also wanted this date value for other…

PowerBuilder ‘Gotcha’ – Column lists do not match - the full story »

Comment on PowerBuilder ‘Gotcha’ – Column lists do not match »

PowerBuilder ‘Gotcha’ – Strings, Describe and Position Attributes

Posted on September 6, 2012 at 6:40 pm in

So I’m getting the position attributes of a column in a datawindow to aid in the display of another visual object. What I initially coded was this: ll_open_x = Long(adw.describe(as_colname + ‘.X’) + & adw.describe(as_colname + ‘.height’)) + 10 I run the window and my visual object is no where to be seen. Looking in…

PowerBuilder ‘Gotcha’ – Strings, Describe and Position Attributes - the full story »

Comment on PowerBuilder ‘Gotcha’ – Strings, Describe and Position Attributes »

PowerBuilder ‘Gotcha’ – Invalid Expression Error Message

Posted on August 31, 2012 at 6:58 pm in

So customer support calls regarding an issue a client is experiencing on a periodic basis. The receive an error ‘Invalid Expression’. To make things worse they get a series of these messages popping up and eventually the application crashes. Great. So we look at the datawindow object on the application window they are having issues…

PowerBuilder ‘Gotcha’ – Invalid Expression Error Message - the full story »

Comment on PowerBuilder ‘Gotcha’ – Invalid Expression Error Message »

Software Application Design – Required Reading

Posted on August 15, 2012 at 7:58 pm in

If you are involved in any way with software design and programming, you really must read the paper Magic Ink, Information Software and the Graphical Interface by Bret Victor. While you are at it, check out his entire web site worrydream.com. One point of particular interest to me was the section on ‘inferring content from…

Software Application Design – Required Reading - the full story »

Comment on Software Application Design – Required Reading »

Sending iCalendar events via a .Net Assembly and SQLServer stored procedure

Posted on July 31, 2012 at 5:01 pm in

As I’ve mentioned in earlier posts, the iCalendar format is a standard way to send event information to a variety of email/scheduling systems (Outlook, Google, etc.). Here is a way to set it up so that you can simply call a stored procedure to send the event. This assumes you have SQL Server set up…

Sending iCalendar events via a .Net Assembly and SQLServer stored procedure - the full story »

11 Comments on Sending iCalendar events via a .Net Assembly and SQLServer stored procedure »

Top