PowerBuilder Tips, Tricks, and Techniques

Berndt Hamboeck

Subscribe to Berndt Hamboeck: eMailAlertsEmail Alerts
Get Berndt Hamboeck via: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn

Top Stories by Berndt Hamboeck

The DropDownDataWindow (DDDW) edit style is one of PowerBuilder's outstanding features. Yes, I know there are a lot of new and exciting capabilities in the upcoming release of PowerBuilder, but in this article I'll try to solve some of the current problems with the existing features that are popping up in nearly every project I've seen. Here I'll focus on DropDownDataWindows, including: How to get started with DDDWs Filtering DDDWs without losing the display value in other rows Catching the collapsing of a DDDW Trapping the cursor keys in a DDDW Autocomplete DDDW values Getting Started The basics are well covered in the PowerBuilder User's Manual, but if you still have problems defining them look at Figure 1. Click on the column you want and its edit style (yes, click on edit on the properties) as DDDW (choose DropDownDW as Style Type). Next, choose your DataWindow, ... (more)

PowerBuilder and Colors

Have you ever looked at a rainbow and wondered how all the colors got there? Or wondered why grass looks green and your jeans blue? Well, if you sit in front of your computer as often as I do, you might not. However, the following problem may have occurred: you want to create a cool window in which the data and the headers are displayed in different colors, but you can't find the right one. If you've come across this situation before, then this article is right for you. What Is Light? Let's discuss a bit of physics. If you look at a cool DVD movie, you hear sound and see pictures... (more)

Working with the Enterprise Portal

An enterprise portal is the converged "hub" of multiple, complementary information management solutions, including document and content management, information search and retrieval, knowledge management, team collaboration, workflow, and business intelligence. In this article, we describe what an enterprise portal is and give you a brief overview of Sybase Enterprise Portal. Then we take a closer look at the portal and go over some of the installation requirements and steps for the Information Edition of the portal. We also delve into how to use a portal and build components (ca... (more)

SQL Anywhere Studio 9 Developer's Guide

As a PowerBuilder developer I'm sure you have already used SQL Anywhere a few times, but did you know that SQL Anywhere owns over 70% of the mobile database market? There are several good reasons for this big market share; it's easy to use, easy to administer, and doesn't take up much space, but SQL Anywhere isn't just for mobile and embedded databases; it's got the features and the flexibility to work as a network server with hundreds of active users pounding away on a single database. And it's got a solid foundation and a long history from its roots with Watcom in the 1980s th... (more)

Administrator's Guide to Sybase ASE 12.5

This month we'll be looking at another book written by Jeff Garbus. This time the book is about Sybase ASE 12.5 systems administration and database administration, where systems administration is the function of installing, maintaining, operating, and controlling the Sybase ASE Server. A systems administrator (SA) is responsible, at the server level, for maintaining a secure and stable operating environment; for forecasting capacity requirements of the CPU; and for planning and executing future expansion. Further, an SA is responsible for the overall performance at the server le... (more)