Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Powerbuilder 7.03 DropDown Datawindow slowness

Posted on 2004-10-28
Medium Priority
Last Modified: 2013-12-26
I have a DropDown DataWindow which allows editing.  There are several thousand results in the result list and that populates fairly quickly, but when you manually type in the field it is painfully slow and there is a noticeable pause between keystrokes as the DropDown scrolls to keep up.
I am new to Powerbuilder any suggestions would be much appreciated.
Question by:booksplus
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Assisted Solution

michaelstoffel earned 720 total points
ID: 12434078
I wouldn't use a dropdown.  Several thousand is useless for a user to actually scroll through.  How about opening up a lookup window with some search capabilites?

Author Comment

ID: 12434234
The users almost always know what to enter and just want to type it in quickly (and have the occasional convenience of a drop down to help in the search).   Unfortunately, its not practical for me to spend too much time on this.  The users would be willing to pay the performance price somewhere else just as long as it doesn't slow down their typing.  Thanks.

Accepted Solution

michaelstoffel earned 720 total points
ID: 12434879
So, how about just having it as plain text entry with a possible lookup window.  Then validate their entry upon saving?
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 18

Assisted Solution

diasroshan earned 60 total points
ID: 12435133

can u post the code u have written in the editchanged event for that datawindow...
maybe the code can be optimised and speed ur work...


Author Comment

ID: 12435946
There is no "editchanged" event on the DataWindow.  There is an "itemchanged" event that fires after the user tabs out.

I had hoped that turning off  the "Edit.AutoVScroll" property on the drop down would fix the problem, but it seems to completely disable the drop down capability.  I'm not sure if this is a PowerBuilder bug or my inexperience.

Author Comment

ID: 12437267
Also -

I can see all the results (very quickly) in the dropdown by scrolling - BUT it takes long for Powerbuilder to scroll to the result when the user manually enters their chioce.

INCREASING points by 50.  

Author Comment

ID: 12437935
This is urgent - increasing points to 500.
LVL 10

Assisted Solution

Sys_Prog earned 60 total points
ID: 12440437
Can u post code in all the datawindow evetnts.

Specially fo these events

1. ItemChnged
2. ItemFocusChanged
3. Initial Population of dw
4. structure of dddw
5. EditChahnged event


Assisted Solution

EdMacke earned 60 total points
ID: 12493888
Does the dddw retrieve sort the result set - I'm wondering if every time you enter a character PB has to search the entire list (something that would be easier / unnecessary if it was sorted)?

Also, I know this sounds stupid, but do you have the horizontal scroll bar enabled?  I've run into problems exactly like you described with hscroll enabled, but it was usually with listboxes.  Give it a try, just to see.

I would also echo others' sentiment that a dddw with 1,000+ items isn't the best idea from a GUI design standpoint.  I can see why you're doing it, but maybe there's another way?

Good luck

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In our object-oriented world the class is a minimal unit, a brick for constructing our applications. It is an abstraction and we know well how to use it. In well-designed software we are not usually interested in knowing how objects look in memory. …
Here is a helpful source code for C++ Builder programmers that allows you to manage and manipulate HTML content from C++ code, while also handling HTML events like onclick, onmouseover, ... Some objects defined and used in this source include: …
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The viewer will learn how to use and create keystrokes in Netbeans IDE 8.0 for Windows.

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question