Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Convert entries in messagebox to a comma-delimited list
Message
De
04/12/1999 17:22:55
 
 
À
04/12/1999 17:12:46
Information générale
Forum:
Visual FoxPro
Catégorie:
Classes - VCX
Divers
Thread ID:
00298547
Message ID:
00298767
Vues:
27
>>Nadya, Edward's suggestion of a grid is even better for this purpose - you can save discrete values into a cursor, and rather than using the non-optimizable INLIST() function, you can use an optimzable IN with a subquery.
>
>As of (I think) VFP 5, INLIST() IS optimizable.

That'd be neat if true, but very tough unless VFP went and refactored it not to used the INLIST function - you have to check each record against the function return. You'd also have to change VFP's refactoring if the INLIST() were used in combination with another function by something, or contained in another expression like an IIF()).

IN with a list of values (eg: ZipCode IN ('06511','90210','66666')) or a subquery is definitely optimizable.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform