PBDJ News Desk monitors the world of Sybase PowerBuilder to present IT professionals with updates on technology advances, business trends, new products and standards in the PowerBuilder and i-technology space since 1994!
To this day my mother
refuses to make deposits
via her bank's ATM. Her
reason is a valid one:
she doesn't trust a
machine with her money.
You get no real
validation from the ATM,
just a receipt stating
the amount you said was
in your envelope.
A component that's
sitting on EAServer
doesn't do us any good
unless we call it from
somewhere. We may call
these components from
several different
sources. In this article
we'll call them from the
Active Server Pages (ASP)
front end.
The HTML DataWindow is a
great starting tool for
any PB programmer. When I
began developing
applications for the Web
knowing little if any
HTML, using the HTML
DataWindow enabled me to
deploy data to the Web
immediately.
PowerBuilder 7's IDE has
many new features that
can speed the development
of an application.
However, I've had a hard
time adjusting to the
change in the database
painter. Despite the
added features, the
catalog maintenance and
database administrator
are slightly more
difficult to use.
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
Techno-Kitten.com
announced the release of
the lastest version of
PBL Peeper. Version 1.3.1
includes a number of
enhancements and bug
fixes and can be
downloaded from their Web
site.
www.techno-kitten.com
PBBrowser Beta 8/19
OOWidgets announced the
availability of a beta
version of
Most PowerBuilder
developers are aware of
object-oriented concepts
like inheritance,
encapsulation, and
polymorphism. A lot has
been said about them, and
I don't want to reinvent
the wheel by discussing
what they are and how
they're used in PB
applications. The main
purpose of this ar
Imagine creating a
DropDownDataWindow look
and feel using HTML form
elements that can show
more than one column in a
ListBox on a Web page.
The data elements could
be generated using Web
server-side technologies
such as JavaServer Pages
(JSP), Active Server
Pages (ASP), and
ColdFusion
My first column on
Sherlock appeared in the
August issue of PBDJ
(Vol. 7, issue 8). In
that article we set up
our development
environment. Now we need
to log in. Before we do
that let's review just a
bit.
This issue of PBDJ
contains an article
written by Tom Hughes
that provides us with a
service object quite
suitable for traditional
two-tier applications. My
article shows how to
expand that technology
and move the object to a
Jaguar component so we
can handle e-mail from a
central spot
This year's TechWave was
a marked improvement over
the last few years.
Overall I'd have to say
that 1994 and 1995 were
the best Sybase Tools
conferences ever. Since
then their value to me
has declined, though they
were still worth the time
and money. The two areas
in which I've been di
'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
Since Web DataWindow
technology is now used as
a building block for many
applications, Sybase
decided to enhance this
functionality and provide
some much needed bug
fixes. I recently met
with the Web DataWindow
team to demonstrate what
I've been doing for my
clients and to discuss
some
One of the greatest
selling points of the
PowerJ development
environment is its
ability to use
DataWindows. The same
DataWindow that's created
in PowerBuilder, and a
major contributor to the
success of that
environment, is available
to the Java programmer
who uses PowerJ.
In this article I'll
share my experiences of
working with the PFC
DropDown Calendar and
show you how to make this
custom user object
user-friendly. If you've
tried to use this custom
visual object, you may
have discovered that the
PFC Calendar won't
populate a calendar if
you use a dat
Almost every application
has one or more
long-running processes.
Typically these are
things like importing,
export and reporting.
Waiting for the processes
to complete can be
tedious for your users.
There are techniques you
can use to make this less
painful. When designing a
long runn
We've finally reached the
end of this series - the
fifth and final
installment on graphing
techniques. By the end of
this article you should
know enough about
graphing to be really
good at it. There's still
a lot about graphing that
I haven't covered, but
there's a lot to discuss
about
There are files that come
with EAServer that were
hidden from me when I
first started using EAS.
These files, primarily
utilities, can solve some
common and important
programming tasks. This
article essentially
covers two of these files
or utilities, one named
javaqry.ssc; and the othe
Overloading allows two or
more functions to have
the same name and return
type, if their signature
is different. The
function signature is
defined by its number and
types of arguments. When
you call an overloaded
function, PowerBuilder
decides which version of
the function to call base
Java servlets, one of the
hottest topics in
programming today, are
Java's method of writing
CGI-type programs that
interact with the Web
browser and deliver
dynamic HTML pages to the
end user. Traditionally
these programs have been
written in C++ or Perl.
Since C++ is compiled to
nativ
So far we've made
significant headway in
our understanding of
graphing. In our first
exercise (PBDJ, Vol. 7,
issue 1) we learned some
of the basics. The next
three articles (PBDJ,
Vol. 7, issues 2, 3 and
4) concerned line graphs.
We created a simple one
and added tool tips to
it. In my
Some of the most popular
new features in
PowerBuilder 7 are the
wizards because they make
it easy to perform
complicated, multipart
tasks. However, the first
time I ran PB7 and
attempted to create a
Jaguar component I was
stunned to find
identically labeled, as
well as nearly identical
After years of
considering what types of
controls to put in a Web
page, the main
technologies that work
are ActiveX, Java and
DHTML. I thought only
Java or ActiveX could
provide the types of
controls I needed, until
I saw the game Asteroids,
written in DHTML.
In my previous articles
on graphing (PBDJ, Vol.
7, issues 2 and 3) we
created a simple line
graph. We then extended
the graph in order to
have a tool tip that
would work with it. This
article will expand on
that idea and show you
how to do a series. My
next article will begin
exploring
Imagine hiring a crew to
put an addition on your
home. As capable as they
seem, you can't help
being concerned over the
fact that they've shown
up for work without any
power tools. Every
instrument they use looks
like it came from Olsen's
Mercantile in Little
House on the Prairie. Whe
Imagine creating your own
Web browser that can
provide the full power of
Internet Explorer (IE)
including scripting,
parsing and rendering of
HTML pages. It has become
standard for stand-alone
and client/server
applications to contain
Web browsers. A perfect
example is Intuit's
popular
In my last article (PBDJ,
Vol. 7, issue 2) I
described how to create a
simple application for
unit testing, and then
explained a simple line
graph that went with it.
This month we'll build on
that concept, using some
techniques I showed you
in an earlier article
(Vol. 7, issue 1) on T
You stumble on a bug in
your application. In
order to troubleshoot it
you need to see the raw
data inside your
DataWindow but the
columns you need aren't
visible. ... You open a
window in your
application, and even
though you don't change
any of its data it still
prompts you to save w
When I sit down to write
this column I always ask
myself, 'What can I write
that will be the most
help to DataWindow
programmers?' At the
moment I'm also in the
final production stages
of my new book, The
Definitive DataWindow.
This morning, while
glancing at my chapter on
'Graphing,'
One of the typical
problems developers face
when using the HTML
DataWindow (HTML DW) is
that there's no
SetRowFocusIndicator()
method to allow users to
see which row is the
current one. This can
confuse the user and lead
to errors. For example,
without a current row
indicator users may
A tool tip, which appears
in several modern
applications, is a small
text area that floats
over an object when the
cursor comes to rest on
it. Microsoft Word has it
- in fact, PowerBuilder
itself incorporates tool
tips. Rest your cursor on
any item in the toolbar
and a moment later a t
Blue Cross and Blue
Shield of Rhode Island
(BCBSRI) is one customer
who's leveraged
PowerBuilder and EAServer
to develop an intranet
solution. This
application has provided
BCBSRI with tremendous
cost savings and enhanced
performance.
In this month's column
I'll show you how to use
the PFC multitable update
service. This service, as
you might expect, allows
the DataWindow to update
more than one table.
Multitable update, one of
the least used PFC
services, has been around
since version 5.0. I'll
demonstrate how you
In Part 1 of this article
(PBDJ, Vol. 7, issue 1) I
compared Java to
PowerScript. We covered
some of the fundamentals
of Java language -
identifiers, primitive
data types and primitive
data type wrappers - and
PowerBuilder's any data
type, and we began to
discuss relational
operators,
You stumble on a bug in
your application. In
order to troubleshoot it
you need to see the raw
data inside your
DataWindow but the
columns you need aren't
visible. ... You open a
window in your
application, and even
though you don't change
any of its data it still
prompts you to save w
When I sit down to write
this column I always ask
myself, 'What can I write
that will be the most
help to DataWindow
programmers?' At the
moment I'm also in the
final production stages
of my new book, The
Definitive DataWindow.
This morning, while
glancing at my chapter on
'Graphing,'
With the industry
buzzwords being Java,
Java, and more Java, I
wrote this article to
provide insight into how
you can leverage your
knowledge of PowerScript
and PowerBuilder to
quickly learn and build
Java programs. I'm going
to assume that you're
familiar with
PowerBuilder and the OOP
Two of the biggest
launches in Rich Internet
Application history took
place in 2007/2008 when
Adobe launched AIR 1.0 in
February '08 and
Microsoft launched
Silverlight (September
'07). At the 6th
International AJAXWorld
RIA Conference & Expo in
October SYS-CON Events is
delighted to be
In PowerBuilder 11.2,
.NET meets J2EE head-on
with the capability to
deploy .NET Windows Forms
and Web Forms
applications (as well as
assemblies and Web
Services) that access
Enterprise JavaBeans
(EJBs) in Sybase's own
EAServer. As you'll see
over the course of this
article, integratin
HarPB is a specialized
utility for checking
PowerBuilder source
objects in and out of
AllFusion Harvest. It
handles the special
requirements of checking
objects out to
PowerBuilder Libraries
(PBLs) and checking
objects in from PBLs.
These operations are
non-standard to most
source cont
Back in 2002, Sybase
announced their
four-phase approach
toward adding .NET
support to PowerBuilder.
Phase 1 was the
implementation of web
services in PB9 and Phase
2 was the release of
DataWindow.NET, which was
packaged with PB 10.
Phases 3 and 4 were the
more significant phases.
In P
I have been asked many
times by various clients,
students, and the IT
curious about
PowerBuilder: When did
Sybase develop the
product and how did it
evolve? I keep telling
this story and answering
e-mails on the subject. I
am now to the point where
I have decided that I
should have PBD
PowerBuilder 11 deploys
entire applications as
.NET Windows Form or Web
Form applications and
deploys individual
components as .NET
Assemblies and as .NET
Web Services. Version 11
consumes resources of the
default .NET framework as
well as resources of
custom developer-defined
.NET res
FEATURED WHITE PAPERS
SUBSCRIBE TO THE WORLD'S MOST POWERFUL NEWSLETTERS
HarPB is a specialized
utility for checking
PowerBuilder source
objects in and out of
AllFusion Harvest. It
handles the special
requirements of checking
objects out
I began my career at RCA
Aerospace and Defense in
1983 and worked at MITRE
Corp., BAE Systems, and
the State of NH. I worked
in the defense field
performing software
In keeping with the
longstanding SYS-CON
tradition of being at the
very forefront of
software development with
all its online and
offline resources,
SYS-CON Media &