Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Array Dimensions are invalid
Message
De
27/05/2003 21:07:50
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00793284
Message ID:
00793331
Vues:
38
David,

I agree that I certainly wouldn't want to work with such a combo (acknowledging that there can be cases, especially when _INCSEEK works well, that it can be OK).

I want to take issue with your "Your network admins will be happier..." and the "load" and "megabytes transferred" stuff.
1) even if the data inolved is 50 bytes wide (both fields combined) it would be about 1 megabyte;
2) there is an excellent chance that the data in question, which is in an array, would still be in OS cache and/or VFP buffers/cache even in the event of a REQUERY so the load on the network would be negligible after first use.

cheers

>Will,
>
>set soapbox on
>
>It's sorta silly to give the user a 22,702 item long cbo in the first place.
>
>Why would the user want to interact with your system like that anyway? Your cbo is populated with employee numbers which makes that the incremental seek value. Why not develop a much faster UI that uses two textboxes, one to enter an employee number and another to allow them to enter a last name. Get the "key" data from them and then present them a candidate list to select from if there is more than one match? ie they type "smith" in and you let them pick the one smith they really want. If they type in a employee number you go directly to that employee's record.
>
>Your network admins will be happier with your app because you'll stop slogging so much data down the wire, your server admins will be happy about the reduced load on your file server and your users will be happy because they don't need to wait for huge cbos to be constructed chewing up megabytes of memory.
>
>Besides what happens to your app in VFP7 when the 32,501st employee is hired?
>
>>Wow, that's a pretty BIG BUG and certainly enough to stop me from working in VFP 8.0 since my framework uses the same approach for all comboboxes. The code ran fine when testing with 8.0 Beta. What's worst functionality that worked in Beta in now doesn't or advertised functionality that never worked?
>
>>>>My problem is a "larger-than-preferred" dropdown consisting 2 fields from a 22,702 record table. This calculates to 45,404 elements which is under the 65,000 Maximum # of elements.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform