>Hi,
>Back in VFP3 or 5, I seem to recall reading something about list boxes having a record limit that could be put into them. I am using VFP6 now but have not used list boxes for anything execpt a few records to be displayed. I now have a need to use the list box for more records utilizing either an array or sql to load a box with about 500-600 records at a time. Has this been a problem, and if so, is it fixed?
>Thanks in Advance,
>Chris
Having just for the sake of curiosity created a listbox with almost 33,000 rows. I think the 500-600 shouldn't be a problem. For the record, I can easily see a situation where you might want that many.
Suggestion 1, use a SQL clause instead of an array. This will get you a major performance benefit over an array, and can be requeried if you are using a parameterized SQL statement.
Suggestion 2. Bind the row source to your sql programatically instead of at design time. This is a reliability issue, I have much better results this way.
Suggestion 3. Make sure to enable incremental search, otherwise your users have to page through all the rows they don't want. Trust me, they will complain about that.
Regards,
Jason
Jason Tryon
Senior Systems Analyst / Technical Lead
eBusiness / iPage