Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alltrim strange behavior
Message
 
To
25/04/1999 11:22:02
Christian Cote
Les Logiciels Onoma Inc.
Longueuil, Quebec, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00212015
Message ID:
00212021
Views:
29
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform