Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Selected Records in List Box
Message
From
18/07/2001 23:12:06
 
 
To
18/07/2001 02:44:51
Ashish Patel
Hindustan Petroleum
Mumbai, India
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00531873
Message ID:
00532361
Views:
13
>Now there are around 15000 records is customer master. Customer Master is having 56 fields. Now we want to filter out certain customer who are marked by a field call TV_OUT or CTA_OUT. So if any of these fields are not empty then this customer should not be displayed in the help listbox. We have used listbox wizard to have custno and name from customer master into listbox.
>
>We are using free tables in our project. If we filter the customer table then listbox display will be very late after we click help button.
>
>How can we make it fast ? Pl. Help

How many records actually get displayed in the list box once the filtering takes place? (Incidentally, I agree with Cetin that SQL should be used instead of filtering). VFP list boxes tend to be slow to begin with and become slower and less predictable past about 50 entries or so. If you are passing that limitation, you might want to consider using something more robust, like dbi Technologies toolkit, as an example.
David M. Stowell
Ravenslake Consulting
Chicago, Illinois

e-mail: davidstowell@ravenslakeconsulting.com
Previous
Reply
Map
View

Click here to load this message in the networking platform