Most new users of PowerBuilder start with SQL Anywhere as the back-end
database engine (formerly Adaptive Server Anywhere or ASA, and before that
Watcom). With growth, a need to shift and adapt to a wider database platform
is thrust on developers by customers. A recent exercise in this regard,
besides re-emphasizing our past amateurishness, has also helped us make a
clean, lean application. This article, besides providing insights on how to
avoid basic mistakes, also has a few tips for our experienced colleagues on
how to do some spring cleaning of established applications.
Our application development started as a hobby without any formal training
(see About the Authors); so our application-making approach was based on
intuition. We found PowerBuilder to be the most suitable platform for our
data- and report-centric needs. It was natural to use Watcom and ... (more)
We make customized electronic medical record formats for physicians. We've
been using multi-select list boxes to enter various choices together as part
of a single column in many DataWindows in our applications. They help enter
some interrelated data faster without creating an independent table and/or
A review of the need, outcome, and sample code are provided with a plea that
a DataWindow edit control for multi-select list boxes should be available in
PowerBuilder itself. It would further enhance the wide variety of entry
choices for developers.
A multi-select ... (more)
Software that is not used is useless.
Facing the challenge that doctors prefer to spend time with their patients
rather than facing the monitor, we have fine-tuned methods in our
DataWindow-based forms so that user entry is quick, painless, and a pleasure.
These include the use of dropdown lists and DataWindows for efficient,
correct and faster entries, in addition to accurately filling in text columns
with limited keyboard entry. Visual guides and markers for data in relation
to patient images are also provided.
Keywords: PowerBuilder, DataWindow, List Select
We ar... (more)
We make EMR (Electronic Medical Record) Software. Being users ourselves, our
development approach has been entirely from the users' perspective. The ease
and simplicity of the PowerBuilder development environment deserves due
credit for the relative success of our efforts. Our main developer has had no
formal training in software, and still treats the development efforts as a
hobby. As we are laypeople, for the most part, some ideas that we have
incorporated may be considered by the more experienced as out-of-the-box
Medical Records traditionally have been textual and ... (more)