As we all know, the DataWindow is a very powerful and flexible control used
for data presentation and manipulation. For the most part, the features that
you get out of the box allow you to create some very impressive applications.
With that said, there is always room for improvement. Fortunately for us, the
DataWindow was built with flexibility in mind. By taking advantage of this
flexibility, we can extend the DataWindow to do almost anything we want.
In this article, I'm going to introduce you to PowerFilter, a control
developed by Jim Reese and available for purchase from
www.PowerToTheBuilder.com. PowerFilter is an easy-to-implement DataWindow
filtering component that gives your application auto-filtering functionality
similar to that found in Excel 2007\2010. It works with your existing
DataWindows and requires as little as three lines of PowerScript to implemen... (more)
There's a reason why software developers like Microsoft update the look of
their applications every two years. It shows the consumer that something has
changed and therefore they need to upgrade, at least that's my opinion.
If this is true, I can only presume that presentation plays a vital role in
the sale of commercial applications. If you're not writing commercial
applications, then it's just a cool thing to do.
Unfortunately, most developers are usually confined to creating applications
with the look provided by the development tool they're using. Fortunately for
us developer... (more)
If you've read any of my past articles, you know that I love a good
challenge, a challenge that really gets me thinking and ultimately ends up
teaching me something. One thing I always wanted to do was create dockable
windows using pure PowerScript. I held off from doing this for some time
because of the almost overwhelming complexity that was inherent with this
type of control. Seeing as this would be the perfect test of my skills, I
motivated myself to do it.
The first thing I had to do before I started was investigate an existing
control so that I could record proper behavior... (more)
PBDJ Feature Story
PowerToTheBuilder.com is a PowerBuilder developer's source for free, open
source, high-quality user interface controls. Using any number of the
controls available can provide your application with an instant facelift.
Integration is easy and becomes less complicated based on the knowledge you
have of your own application.
Inherently, PowerBuilder doesn't provide designer support for custom visual
controls. The PB UI Controls therefore must be tested by first calling its
exposed functions, then running your application. This causes several
problems. First you ... (more)
PowerBuilder offers some dynamic querying capabilities. For simple scenarios
it works quite well. But what if your scenario isn't simple? What if you
wanted to write a database-querying tool that provides stored procedure
compilation, ShowPlan display, or the execution of large complicated batch
I was writing a database-querying tool that was destined to work against our
ASE database (and ODBC connections but, that's a whole different article). At
first I tried to use the PowerBuilder dynamic SQL functions but found it to
be very limiting. That solution was too simple a... (more)