This is part of my project ‘100 Days of PowerBuilder’ which is a series of discussions focused on basic PowerBuilder development. Note: This article is written with examples created in PowerBuilder version 12.5. The same steps would be almost identical with any version going back to 9. When you first install Powerbuilder Classic and the…
- .ics
- .NET
- Active Directory
- C#
- Citrix
- COM
- Connection string
- Dashboard
- datawindow
- debug
- disaster prepardness
- ETL
- EVENTCREATE
- Facsys
- frogs
- games
- MDI
- mySQL
- ODBC
- OLEDB
- Outlook
- parenting
- PB.INI
- pfc
- Powerbuilder
- Powerbuilder OLE
- Powerbuilder Tutorial
- programming
- regasm
- REPORTEVENT
- SCOPE_IDENTITY
- source control
- SQL Anywhere
- SQL Native Client
- SQL Server
- TWAIN
- Uniface
- Visual Basic
- web service
- Windows API
- Windows Event Log
- Windows settings
100 Days of PowerBuilder – Day 1: Creating a Workspace
PowerBuilder – Where is Autoscript?
The autoscript feature in Powerbuilder is something I’ve come to rely on quite heavily, especially when dealing with user objects and such which you may be unfamiliar with (…do I pass two ints and a string or two strings and an int?). However, it is a feature which can frustrate you in just trying to…
PowerBuilder – More Datawindow Mouseover Effects
So I download the latest Chrome browser beta the other day (v17) and I notice a neat effect on the tabs prior to applying my custom settings. A gradient centered on my mouse pointer passed across the tab as I moved it. It was very subtile but noticiable if you were paying attention. Naturally I…
PowerBuilder 12.5 ‘Classic’ – New Feature
I just stumbled on a neat new feature in the datawindow painter, specifically on the background tab of a column. The Gradient stuff was added in 10.5 (I believe) and now you can actually see the numeric value of the slider bar without having to pick through the source. Refer to the following: All of…
PowerBuilder ‘Gotcha’ – Tab Label Disappears
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…
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…