>>>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 VFPAfter 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?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham