Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set Exact On or Off
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01517890
Message ID:
01517906
Views:
39
>>>>That said, SET EXACT is scoped to a datasession. So, if your form uses its own datasession, when you close it the SET EXACT no longer has any effect. If it's OK for SET EXACT to be ON for the duration of the form, it might be OK to leave it in the .Load.
>>>
>>>Thank you. Everything you stated makes sense. The only place, I can think of, that I would need to SET EXACT ON is where I need to use SEEK() on exact value.
>>
>>SEEK doesn't search for a partial match, you're getting confused. May be you're thinking about SET ANSI ON and SQL.
>>
>>See also String comparison in VFP
>
>After I changed the code from SET EXACT ON to OFF the code that didn't work started working. Here is an example:
>
>I have an index key:
>
>REC_ID + PART_NO + DTOS( SOMEDATE )
>
>When I was using
>
>SEEK '1' + cVariable && the cVariable had a value of valid entry in the cursor
>
>The pointer was going to EOF().
>
>Once I changed to SET EXACT OFF the above SEEK started working.
>
>Does it make sense?

Yes.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform