Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find combo too slow
Message
 
To
13/09/1999 12:00:56
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00264033
Message ID:
00264059
Views:
31
Try using a grid instead. You can download ingrid File#9172 to add incremental searching.

>I presently have a form that maintains informtion about homes. I use a button to do a "fast" find of a home. That button calls a small form with a combobox on it to list the homes by last name + first name. I found that when I populated the home file with a few hundred homes the "fast" part of find went away. The find form takes several seconds to load the combobox before it appears. I seem to be suffering from a lack of imagination here and would like some suggestions to improve performance.
>
>I tried setting the combo box's RowSource to Home.Last_First with Home.Order set to Last_First in the dataenvironment.
>
>Then I tried an SQL along the lines of:
>SELECT ALLTRIM(Home.Last) + ", " + ALLTRIM(Home.First) AS LastFirst ...
>in the form.init
>
>Both failed to improve performance
>
>
>Thanks in advance
>Terry
Roi
'MCP' Visual FoxPro

In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform