WE HAVE A STOCK TABLE WITH MORE THAN 20,000 RECORDS.

WHEN USING POPUPS TO LIST ALL THE STOCK ITEM WITH STOCK DESCRIPTION, IT CAN SCROLL TO ABOUT 1000 RECORS AND IT JUMP BACK TO THE FIRST RECORD.

SOME TIME IT GIVE A MESSAGE :

    NOT SUFFICIENT MEMORY

WE ARE USING AREV 3.1 AND WINDOWS 98.

IS IT BECAUSE OF 64K LIMITATION.

IS THERE ANY WAY TO CONFIGRE THE SYSTEM OR ANY THIRD PARTY TOOLS

TO SOLVE THIS PROBLEMS.

PLEASE ADVISE.

ANY HELP ARE MUCH APPRECIATED.

JEFFREY.

This has always been a problem in AREV. The maximum size of the data in a Popup can be anywhere from 32K to 40K. After that point you get an error message to the effect that the Popup has exceeded the memory size … Years ago on the CompuServe board I think I remember someone who had a substitute for the popup processor that didn't have memory limitations (my recollection is that it paged the data). It also didn't create a browse list if the select list exceeded some arbitrary size (32K, I think). Maybe Sprezz or Steve Smith can offer you some help.

Don Miller

C3 Inc.

PopupBtree 2.0 (Copyright 1992 by Atkin & Associates) may be what you are looking for.

---

2. What is PopupBtree?

PopupBtree is a popup utility specifically designed to display sorted

popups without performing a SELECT. This is accomplished by maximizing the use of Advanced Revelation's indexing structures and information.

PopupBtree is intended to provide users/applications with a search function not provided within the Advanced Revelation tools.

PopupBtree is not a replacement for the Advanced Revelation POPUP function but is a complementary product. PopupBtree was developed by Atkin & Associates and has seen over 3 years of real-life use.

PopupBtree's display order is based on Advanced Revelation indexing information. Since PopupBtree uses existing indexing structures, you do not need to rebuild the indexes of your existing applications. All versions of Advanced Revelation up to and including 3.0 are supported.

2.1 PopupBtree Features

Uses index information for searches and display order; instantly displays a sorted popup.

Incredibly fast! Turbo mode allows a popup to be displayed without reading the data table. All popup information can be stored in the index.

No Popup size/memory limitation. The popup information is 'paged' rather than buffered, minimizing memory utilization. PgUp and PgDn keys are supported allowing all popup data to be scanned.

Indexed symbolic columns supported, allowing the display of a selected

subset of a data table, i.e. Active Employees vs. All Employees. Build

intelligence into your popups.

Multiple views/Popups. Multiple data views are available within a single Popup. The F2 Options key displays a list of the views available, i.e. Customers by Company Name vs. Customers by Primary Contact Name.

---

ATKIN & ASSOCIATES

100 Broadview Avenue, Suite 302

Toronto, Ontario, M4M 2E8, Canada

Phone (416) 778-0623

Fax (416) 778-0648

http://www.atkin.com (but no info on the software)

As of 1992-93, the single unit price was $90 USD.

I'm sorry but Pop.Up is designed to select one or more items from a list. A list of 20,000+ items seems rather unwieldy. Can you not narrow the list of records to be presented before doing the PopUp?

]] Can you not narrow the list of records to be presented before doing the PopUp?

This is easy to do by pre-selecting a set of criteria before requesting the popup or you can add the selection process, if it is the same each time, by inserting the SELECT … in the first of line of the "Explicit popup information." prompt.

My question is the usefulness of any sort of popup if one needs to search through 20,000 records or so!!!

Thanks for all the suggestions.

I will try on it.

Thanks.

View this thread on the forum...