What is the recommended procedure for listing table data on forms for an app.

For example if I call a popup on a form using the menu or a button and a quick event the popup will take some time if the table has 500 or more items.

I understand that there is some overhead involved and I am using oiwg 3.4 because I read that it populates by page. When I can I do not use the "by" to avoid sorting. I have also used a xreflookup for finding related data by name but this also takes some time.

By some time I mean in comparision with a arev F2 lookup and the arev "LIST filename" from a TCL window.

Is there another method I should be using to display table data for a user to search and find the item, get the id, to read into the form?

Popup and Ixlookup are the 'normal' processes for

finding a 'key' for a form. Some of us have written

lookup front ends to improve performance.

The processing time is something you will probably

have to get used to.

dsig

David Tod Sigafoos ~ SigSolutions

dsig@teleport.com voice: 503-630-8080 cis:70302,77

NOTICE FOR RTI FORUMS: The message above is an answer to a user request and should

be taken as personal opinion only.

Although care was taken to not hurt anyones feelings or impugn

the quality of any product, support or idea IF there is an exception taken please note in detail the offending portion of

** the note and email me. I will take all notes under advisement.

–

Cameron,

As David mentioned, some of us have written our own front-ends and custom lookup routines. I have written one called the RSU (Record Search Utility) which is designed to be a generic tool that can be attached to any window as a popup replacement. It uses Btree.Exract whenever possible and therefore attempts the optimum select method.

If you are interested let me know and I'll post another response with a link to it. Cameron Purdy once created a link so my guess is that it is stored somewhere on this website but I don't know the location.

dbakke@srpcs.com

SRP Computer Solutions

B Cameron,

(BTW, nice name!)

It sounds like you want to use BTree.Extract to get the list of keys and use the K (list of keys) data source on the Popup – that is you want to pass it the list of keys to avoid R/List.

OTOH I may not have understood the question. It may help you to look at the stored procedure called Popup_Sub … it is what populates the Popup window and we ship it as part of the source we've released in the OpenInsight Works program.

Hope this helps,

Cameron Purdy

info@revelation.com

C Purdy,

(BTW Nice name back @ u)

I guess my question was what developers have come up with as the best solution to display a file so the user can select an item for further processing. (ie. read algorithm once key is found)

Obvioulsy I would like to minimize the processes to locate the key and in some cases not even display the key to the user. Especially if the app is set up with alot of sequential counters.

Can you expand on your suggestion.

View this thread on the forum...