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 a few
columns from the employee table. Here is my sql for the DataWindow in Figure
Once we have created it I get the DataWindow painter shown in Figure 2.
There are several changes that we need to make. Let's change the status
column so it's no longer a set of radio buttons. This is a read-only screen
so let's remove the status and add a computed field.
To do this let's remove the Status column altogether. Then add a computed
field in its place.
Let's pause for just a moment and talk about that expression for the computed
field. This is an IF function. The format is IF(EXPRESSION, TRUE, FALSE). If
the expression evaluates to TRUE then the function returns the first
argument, othe... (more)
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 the programmer the maximum number of options
while minimizing the programmer effort. In other words, default as much as
possible but allow the programmer to move beyond the defaults.
We have several action items to implement:
Do the housekeeping to get an application going Create a window for sorting.... (more)
I'm considering changing my emphasis in my column. Since speaking with some
people at 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 tasks faster than C# or even VB.NET.
So why is .NET used by more companies?
Mine would just be a guess and in fact, the answer is irrelevant. I'm here to
tell you that Sybase is making an obvious push to regain some... (more)
We are going to create a bare-bones email object. Of course you can expand
that in the future if you like, but for now, let's just create the
functionality that we need.
I start by creating a custom class. In case you aren't familiar with the
process look at Figure 1.
Let's start with an instance variable.
N_cst_mailer Instance Variables
private mailMessage io_mail_message // The message to send
I made the instance variables private so let's write a couple of functions to
populate our mail Message. We'll start with the TO. Note that the
io_mail_message contains an array of objec... (more)
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 set the microhelp,
but that function is only available in MDI. If you are using any other
application type, then this is not available to you.
Even if you do have an MDI, I have found that the microhelp is not as useful
as I would like. The microhelp is always on the frame, nowhere near the
column. ... (more)