OI index 'list truncated' ??? (OpenInsight Specific)
At 05 MAY 2000 08:39:09PM Gene Sorbo wrote:
I have an index lookup quickevent tied to a dropdown for the field NAME (employee names) on one of my application forms.
When the dropdown is pressed, a single column of indexed values is returned, but not all of the values are present. At the end of the list is a value of "List truncated"…?
I have rebuilt the index via the OI Database Manager several times, but to no avail.
OI 3.61 full development copy.
Anyone with any ideas?
TIA.
Gene
At 06 MAY 2000 03:23PM Gene Sorbo wrote:
Additional info - key length for all values combined around 32000 bytes. Length of all indexed values around 60000 bytes.
I understand that the key length can be ] 64k, but 32…?
Gene
At 07 MAY 2000 06:31AM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Windows controls have built in limits. Regretfully you have reached the limit of a dropdown.
World Leaders in all things RevSoft
At 07 MAY 2000 05:35PM Oystein Reigem wrote:
Gene,
If your list is too large for the control, you can try to present it in chunks or in a hierarchical way. First get the whole list with Collect.IXVals.
But if the whole list of indexes gets larger than 64K, Collect.IXVals will not get the whole list. Then you must instead read pages from the index with Btree.Read, which makes it a bit more difficult.
—
Chunks:
E.g, present the beginning of the list, with a special "More…" entry at the end:
- Albright
- Anderson
- Beck
- Ford
- Lee
- Lyle
- Nixon
- More…
If the user selects "More…" go on to display the next chunk.
Hierarchically:
E.g, use a hierarchical list box, and first just stuff it with the initials:
- A
- B
- F
- L
- N
- P
- R
- S
- T
- W
Then if a user clicks a letter (e.g L), expand the list on that letter:
- A
- B
- F
- L
- - Lee
- - Lyle
- N
- P
- R
- S
- T
- W
If the user clicks a different letter collapse the old letter and expand the new one.
But note the following: A hierarchical list box will usually contain the whole hierarchy - in your case both the letter entries and entries for all the names. It contains all the data for both the visible entries and the invisible ones (those that are hidden because their letter entry is collapsed). But in your case there isn't room for that. (I think I read that a list box has a limit as low as 8K.) You must programmatically change the the content of the hierarchical list box yourself, with handlers on the DBLCLK event. It's really not too difficult. (And if it does get difficult there are people who've done it before and can help you.)
- Oystein -
At 08 MAY 2000 07:04AM Gene Sorbo wrote:
Great alternatives to ponder.
Thanks for your help!
Gene
At 08 MAY 2000 07:38AM Oystein Reigem wrote:
Gene,
I'm curious to know if you've got the "easy" or "hard" problem ("hard"=index ] 64K).
- Oystein -
At 09 MAY 2000 03:23PM Gene Sorb0 wrote:
Oystein,
The easy one, dropdown window control can't handle more than 32k… .
Thanks.
Gene
At 10 MAY 2000 05:00AM Oystein Reigem wrote:
Gene,
Just another thought. A few of us have discussed the possibility of stuffing the LIST while the user keys in the first characters. E.g, the user keys in an "S" and voila - the control displays all names starting in "S". The user keys in the next character, e.g "O", and the list shrinks to just those names starting with "SO". I can't remember if anybody actually said they implemented it, although I believe several must have done so.
Do a site search on "Collect.IXVals". You might find other relevant postings too.
- Oystein -
Øystein Reigem,
Humanities Information Technologies,
Allégt 27,
N-5007 Bergen,
Norway.
Tel: +47 55 58 32 42.
Fax: +47 55 58 94 70.
Home tel/fax: +47 56 14 06 11.
