Powerbuilder 7.03 DropDown Datawindow slowness

Posted on 2004-10-28
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
    LVL 5

    Assisted Solution

    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

    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.
    LVL 5

    Accepted Solution

    So, how about just having it as plain text entry with a possible lookup window.  Then validate their entry upon saving?
    LVL 18

    Assisted Solution


    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

    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

    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

    This is urgent - increasing points to 500.
    LVL 10

    Assisted Solution

    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

    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Lean Six Sigma Project Manager Certification

    There are many schools of thought around successful project management, but few as highly regarded as the Six Sigma and Lean methods. With 37 hours of learning, this training will explain concrete processes for increasing efficiency and limiting wasted time and effort.

    Update (December 2011): Since this article was published, the things have changed for good for Android native developers. The Sequoyah Project ( automates most of the tasks discussed in this article. You can even fin…
    Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
    This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
    The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.

    856 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

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now