Kbase 15095: BROWSE auto-seek takes too long for very large query
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
BROWSE auto-seek takes too long for very large query
The "auto-seek" on a browse is the feature where as you type a letter,
the browse automatically selects and scrolls to the first record that
begins with the letter.
For very large queries, the auto-seek can take a long time. To get
around this:
(1) Define the query as INDEX-REPOSITIONED.
(2) Include a trigger like the one below:
ON ANY-PRINTABLE OF browse-1 DO:
FIND FIRST <tablename> WHERE <fieldname> BEGINS KEYLABEL(LASTKEY).
REPOSITION browse-1 TO RECID RECID(<tablename>).
RETURN NO-APPLY.
END.
Progress Software Technical Support Note # 15095