Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Ascan exact in select-sql
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Versions des environnements
Visual FoxPro:
VFP 9
Divers
Thread ID:
00973127
Message ID:
00973198
Vues:
20
Hi Peter,

It looks like VFP uses internally a single routine to compare strings. Both, the "=" operator and ASCAN() seem to call this function. Therefore, inside a SELECT statement ASCAN() compares string according to the current SET ANSI setting. If you insert SET ANSI ON right before the select statement, you get the same result as with the SCAN loop.

BTW, you should add NOFILTER to the second SELECT statement. Otherwise, the code runs eternally, because VFP creates a filter.
--
Christof
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform