Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Slow Custom Incremental Search
I've created a custom incremental search which I use on a grid. I intercept keystrokes at the form level and build a string, which I then use to seek the table to which the grid is bound. I use a timer to reset the string if 1.5 seconds of inactivity occur.
It works OK until I hit a space, at which point it slows down considerably (about a 1-2 second delay). I've tried creating an index with no spaces and ignoring when the user hits spacebar, which does not help. As far as I can tell, my index is Rushmore optimized: upper(vname).
I've also timed each step in my keypress code, and none of them even register except the seek, and it usually takes less than 0.1 seconds, including when I hit the space.
I don't want to use a listbox because of the space issue, which does not work with the built in incremental search. I know Tamar Granor did a piece on QuickFill in listboxes in the Sept. 98 FP Advisor, which I no longer have.
Any ideas on how to speed this up, or on how to use a listbox and have it include the spaces in the incremental search?
Thanks,
David
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement