Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Alltrim strange behavior
Message
 
À
25/04/1999 11:22:02
Christian Cote
Les Logiciels Onoma Inc.
Longueuil, Québec, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00212015
Message ID:
00212021
Vues:
27
>HI Nick,
>When I do it, I do not get any rows.
>
>Thank you for your help,
>Christian

Hi Christian,

PMFJI, but try using:

lcvalue = ALLTRIM(ThisForm.TxtAddress.Value)
SELECT Company, Address FROM Companies WHERE ALLTRIM(Address) == lcvalue INTO CURSOR MyCursor

Note the ==. This will be an exact match.

As Nick mentioned, you'll get much better performance by evaluating the vaiable once rather than for every row.

hth,
George

Ubi caritas et amor, deus ibi est
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform