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.
Background
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 th... (more)