Information générale
Catégorie:
Codage, syntaxe et commandes
>>>>Can anyone offer explanation for slow combo box loading?
>>>>
>>>>I don't know why but sometimes the loading of some combo boxes seems to be very slow.
>>>You are working with VFP3 or VFP5?
>>>How many records do you have to load in combo box?
>>
>>VFP5a SP3. About 6000 records.
>Shihchau,
>
>The time it takes to load the combo is related to how the combo is loaded, is it rowsourcetype alias, or sql? Does it get its data from a view, a table, and array, or is it loaded manually?
>
>BTW, I sure I don't ever have to select from 6,000 options in a combo box. That really isn't the best way to present a user the choice of one out of 6,000 options.
I tried both SQL and ALIAS. SQL seems to be faster but not fast enough.
I agree it is not a good idea to use combo box for anything more than 500. The reason is because I want to limit the choice to those in the list and to allow user to do simple incremental search. In fact I also have a popup search dialog for them.
Any suggestion on what to use? I didn't choose textbox because I need to code to limit their choices. May be I have to use textbox after all?
Précédent
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