auto complete for database fields

Author: None (None)

In the web environment there is very helpfull feature called autocomplete.

Several customers asked for this feature in our Uniface application.

Functionality: starting fill in text in an editbox (database field) there is shown an additional trop downbox. This box offers all field values of the database starting with the text that is typed in the editbox. There should be the posibility to set additional filters.

3 Comments

  1. Hi,

    what you discribe is what has become popular in several web developments aswell as in adress fields of the major browsers.

     

    To solve this you will have to trigger the database very often- or to be precies: AFTER every change within the field.

    Web techniques limit their request to the actual field which reduces the data volume and overhead caused by several requests. The response time mostly turns to get below 50ms!

    I think Uniface is not capable to reduce the data amount to that little. The createt SQL packages always take ALL FIELDS (if i remember right!).

    On a big database this could cause some trouble i guess. But it could look like:

    • get the current input
    • retrieve every field, containing this value
    • put the results in the drop down box

    This could be fired by the "Start Modification" trigger! Maybe this is worth a try for you?

     

    Cheers,

    -GHAN-


    Author: -GHAN- (hansen@ahp-gmbh.de)
  2. Hi Martin,

    what you are after is the functionality we enjoy on windows help files.

    You have a long list of entries and while you type, the list is positioned to the matching word (or the next one).
    To do so, ALL values have to be read from the database at once,
    (or you read always with the text entered as profile) which keeps the database very busy.

    For me, this makes only sense if you have only a couple of distinct values (the famous List-Of-Values).
    Here you can use a Combobox or a DETAIL-Trigger which activates a "select distinct" and let you select an option.

    Success, Uli

    P.S: plus a lot of other possibilities depending on your specific environment.


    Author: ulrich-merkel (ulrichmerkel@web.de)
  3. ...and here is an old-skool client/server example that comes close:

    http://www.tonymarston.net/uniface/tip41.html


    Author: Arjen van Vliet (arjen.van.vliet@uniface.com)