Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to equal two Characters
Message
From
27/01/2010 17:51:57
 
 
To
27/01/2010 15:03:32
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01446224
Message ID:
01446263
Views:
29
>>>Hello i have the following code
>>>
>> >
>>>MESSAGEBOX(thisform.pageframe1.page5.txtnum2.Value )&& pelt0006
>>> MESSAGEBOX(cNextnum)&& pelt0006
>>> IF cnext == thisform.pageframe1.page5.txtnum2.Value
>>> MESSAGEBOX('caught')
>>> ELSE
>>> MESSAGEBOX('not caught')
>>> ENDIF
>>>
>>>
>>>Any one can tell me why the message "Not Caught" comes up?
>>>i use if cnextnum== and = no difference
>>
>>Try
>>
>>IF ALLTRIM(cnext) == ALLTRIM(thisform.pageframe1.page5.txtnum2.Value)
>> MESSAGEBOX('caught')
>>ELSE
>> MESSAGEBOX('not caught')
>>ENDIF
>>
>yea alltrim works(thou i have to figure what it really does)
>YOu >all :D

The textbox can have spaces in the value -- it is based on the size/length of the textbox. The == means exactly the same so any spaces in one that is not in the other is considered different. Also, the case of the text matters as well. So you might want:

IF UPPER(ALLTRIM(cnext)) == UPPER(ALLTRIM(thisform.pageframe1.page5.txtnum2.Value))
...

If the above had been:

IF thisform.pageframe1.page5.txtnum2.Value = cnext
...

Then it could possibly match -- the cnext field controls the amount of comparison between the two values:

"ABC" = "ABC" && true
"ABCDE" = "ABC" && true
"ABCDE D" = "ABC" && true again
"ABCDE" = "ABC " && not true -- the spaces in the second makes it different from the first
Previous
Reply
Map
View

Click here to load this message in the networking platform