You get a call from customer support regarding a client who is reporting that the tab labels are all ‘grayed out’ on a particular window. You get a screen shot and see that, yes, they are. These tabs have been disabled within the application by various other processes. Furthermore you find out the client is…
You are currently browsing the PowerBuilder category
PowerBuilder ‘Gotcha’ – Tab Label Disappears
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…
PowerBuilder – My source control is Wacked…
A long time ago I was messing around with the idea of using Mercurial source control with with PowerBuilder. I had set up a Mercurial tool called HGSSC which allowed interaction via the MSSCCI API. I then fired up PB and brought up the workspace properties and yes, the Mercurial client was a choice. So…
PowerBuilder Assertion Failure
Here is a minor head scratcher in PB11.5. IF Len(dw_1.object.column_name[1]) > 50 THEN // and so on This gives you a nifty messagebox: To fix this do something like: IF Len(string(dw_1.object.column_name[1])) > 50 THEN… or string ls ls = dw_1.object.column_name[1] IF Len(ls) > 50 THEN… Since there are two Len methods (one for blob and…
PowerBuilder – Where is the PB.INI file?
So I’m looking for the Custom Color settings that I have set up in PB (11.5.1) and think PB.INI? Registry settings? magic? The first two places don’t give me the information so “Google to the Rescue”. Paul Horan had a blog entry (old Sybase site since dead) on this and says it’s kept in the…
PowerBuilder – Datawindow ‘SuperSpy’ tool
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…
PowerBuilder ‘Gotcha’ – Selectionchanging event on Tab controls
Selectionchanging is an event on a tab control which is triggered, according to PowerBuilder help, ‘when another tab is about to be selected.’ From this description you might think that this means changing from one tab to another; this is only partially correct. This event is triggered also when the window opens. Depending upon your…
Calculate the Last Day of the Month
Here is how to calculate the last day of the current month. Powerbuilder date ld_eom ld_eom = RelativeDate(Date(String(Month(Today()) + 1) + "/1/" + String(Year(Today()))), -1) SQL Server SELECT DATEADD(DAY, -1, DATEADD(MONTH, DATEDIFF(MONTH, 0, Getdate()) +1, 0)) I quess SQL Denali has a new function (EOMONTH) to do this too. SELECT EOMONTH(GETDATE())
Joining to a Table Function in SQL Server
Following up on my previous post, SQL Server (since version 2005 while in SQL 90 compatibility mode) provides the ability to join to the table created by a parameterized table function. In earlier versions you were not able to use a table function with a dynamic parameter or even join to it. If you needed…