Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What to use, SET EXACT ON or ==?
Message
 
To
16/02/2007 19:53:13
Neil Mc Donald
Cencom Systems P/L
The Sun, Australia
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01196479
Message ID:
01196846
Views:
9
>Hi,
>I have recently done some performance testing on large datasets in VFP9, as result we are now using SET EXACT ON & SET ANSI ON and not using "==" as it does have a perceivable impact on performance when processing large amounts of data.

SET EXACT ON and == are NOT equivalent. == compares strings for exact equality while SET EXACT ON pads the shrter string with spaces and then comapres them. This means that if the difference vetween two strings is trailing spaces then SET EXACT ON will NOT notice the difference while == will.
Previous
Reply
Map
View

Click here to load this message in the networking platform