General information
Category:
Coding, syntax & commands
>This is an example of FoxPro's somewhat 'faulty' logic of comparing strings. FoxPro checks each character on the right side of the expression to each character of the left until it reaches the end of the string expression on the right. (eg if 'ABCDEF'='ABC' it compares the 'A','B','C' and then hits the end of the string) Fox then asks itself if it found any that didn't match. Since it didn't, Fox says that the strings must be equivillant. That's why you NEVER use an expression using '' (eg if 'ABCD'='') This will ALWAYS be true no matter what variable you use.
>
>If you're looking for a quick fix, simply use the double equals (==). This forces Fox to check not only for content, but for length of the string as well.
>
>P.S. make sure you are indexed on alltrim(ID) or Rushmore isn't used.
>
>Good luck.
>
>Tom
PMJI Tom,
What's jelly to some is jam to others:-). I use the "=" extensively knowing that it means "begins with". It's an extremely useful construct that I use over and over. Other languages are lacking in this regard, IMHO
Cheers
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only