Welcome!

Richard (Rik) Brooks

Subscribe to Richard (Rik) Brooks: eMailAlertsEmail Alerts
Get Richard (Rik) Brooks via: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Latest Articles from Richard (Rik) Brooks
I am here to tell you it’s true. You can write iPad applications in PowerBuilder. I’m sure that you are waiting for the other shoe to drop but ladies and gentlemen, there is no other shoe. It is simply the truth. You can write iPad applications in PowerBuilder. Those of you who have i...
Normally I try to write applications on the DataWindow or Appeon but every now and then I get a question that makes me sit back and say, “Huh?” In this case the question concerns the PostOpen event. I’ve seen that event named different things: ue_post_open, postOpen, post_open, ue_pos...
Every programmer knows about the IF command. It's pretty much a fundamental part of the syntax of every computer language that has ever existed. I don't need to explain how it works. The DataWindow can't use the IF command though. It does, however, support an IF function. In its sim...
Have you ever used a datastore that ran without a problem while you were developing your application, but once you've compiled it stopped running? Let me tell you that's a difficult bug to fix. I remember it so well. I kept going back and forth. How in the world could the DataWindow w...
Security is a must for most corporate applications. This article will give you a starting point to designing and implementing your own. We will do it with a table that is added to the example database and implement it in ancestor code. The idea is that you should only have to add rows ...
Normally I write columns about the DataWindow or Appeon. This month though I ran into an interesting little logic problem and when I solved it I realized it was really a nice piece of code so, even though it is not in my normal genre I thought I’d share it. I was tasked with allowing ...
Sybase I am convinced that PowerBuilder is poised for a mighty comeback. The fact is that still today PowerBuilder is by far the most productive development tool available. It eclipses all the rest. An experienced PowerBuilder programmer is demonstrably more productive and can finish t...
In my last article we explored what I call Advanced DataWindow Sorting. We covered everything that we need for the DataWindow. In this article we are going to polish what we did last month and make it look professional. The main area of concern is our sort selector window as seen in F...
This article provides a means of automating the sorting of DataWindows... not just grid DataWindows as discussed in last month’s article, but all DataWindows, regardless of display format. Bear in mind that we are writing programmer tools. When writing for programmers we want to give ...
This article describes how to create a grid presentation window that allows sorting by clicking on the column header. To begin we need to create a grid DataWindow. I’m selecting just few columns from the employee table. Here is my sql for the DataWindow in Figure 1. Once we have crea...
This is the third and final part of a series presenting a proposal for the use of the tag property of DataWindow columns. My original thought was to provide a means to automatically set a microhelp for each column. Of course, if you are using an MDI application you have a function to s...
This is the second part of a two-part article. In the last article we learned how to use the tag property to create our own microhelp and automate it. In this article we are going to go one step further and use the tag property for other things. The list of items that I used the tag p...
Have you ever seen a form that has its own microhelp that changes when a field gets focus? I’m sure you have. You might see a window and at the bottom of the window is a line that says, “OPTIONAL – Enter the employee birth date,” when a field is entered. We are going to create a simple...
This month the article is not exclusively about DataWindows. To be sure it is about DataWindows, just not exclusively so. This month we are going to have to stretch our skills just a little. The goal is to replace SQLCA with something a little more robust. Essentially we are going to ...
One of the most useful custom objects that I’ve ever written is my master_detail object. It holds a prominent place in my toolkit. This article will take you through the steps of how to write one and in the process de-mystify the object. First we want something that looks like Figure ...
Service objects were introduced for PowerBuilder at about the same time as the PowerBuilder Foundation Classes. Much like the PFC, most programmers found reasons not to use them. In this article we will reduce the complexity of these objects and in so doing perhaps open a new world of ...
Dear Cliff, You would salivate at the stuff I'm doing. If you thought PowerBuilder was nice, Jaguar blows it clean away. The stuff I'm doing with Jaguar is beyond belief.
In the October issue of PBDJ we worked on the design for our mail server on Jaguar. This is more accurately called an MDA, or Mail Delivery Agent. What we're writing isn't the application that will receive raw messages from the Internet, parse them out, then store them for another appl...
'Welcome back, my friends, to the show that never ends, we hope you will attend, step inside, step inside.' Those words - from an old song by Emerson, Lake and Palmer - have been floating through my head all day, ever since I decided on the subject of my next series of articles on the ...