Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combobox trick
Message
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Title:
Miscellaneous
Thread ID:
00416387
Message ID:
00416861
Views:
18
>Timothy,
>What you're talking about is what is often called a "Quicken-style" combo after the accounting program that used this type of combobox. If you search under 'Quicken' you should find several in Files.
>
>However I am more concerned with your putting 500 records into a combobox. Combos and Lists get unstable after about 200 records, and will become slow to load and slow to react to user entry. You might consider building a textbox/button/grid combination which handles the data much faster. Let the user enter data into the textbox,using the InterActiveChange() to search for the 'next match'. Then if they want to see a list use the button to pop up a grid (visible = .T.) with the closest record showing.
>
>The problem with 500 records is that later they're 600, then 1000 and you have users screaming about speed.
>
>My $.02 US
>
>Barbara
Actually there is really less than 100 items that will actually make it into the combobox via sql statement. I could not find anything on quicken in the files section except the calculator demo.
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform