Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alltrim strange behavior
Message
From
25/04/1999 11:08:55
Christian Cote
Les Logiciels Onoma Inc.
Longueuil, Quebec, Canada
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Alltrim strange behavior
Miscellaneous
Thread ID:
00212015
Message ID:
00212015
Views:
57
HI,
I am using a syntax taht goes like this :
SELECT Company, Address FROM Companies WHERE ALLTRIM(Address) = ALLTRIM(ThisForm.TxtAddress.Value) INTO CURSOR MyCursor

My problem is that the rows selected are the ones that contain the trimmed value of Txtaddress.Value AND the the companies that has a empty address field ("").

Am I missing something or what ?

Thank you for your help,
Christian Cote
Next
Reply
Map
View

Click here to load this message in the networking platform