Hi Nadya,
the code is tested with VFP9
SET NEAR ON
after locate
EOF() = .t.
>I'm sure SET NEAR ON worked correctly in VFP6. Perhaps, where is a bug in version VFP8? Do we have the same behavior in VFP9?
>
>Well, it would help, if I can read documentation. It clearly states, it applies to FIND and SEEK and doesn't mention LOCATE.
>
>>Hi everybody,
>>
>>I have these values in my cursor
>>
>>CodeVal
>>0100
>>0101
>>0110X
>>etc.
>>
>>I do
>>SET NEAR ON
>>LOCATE FOR upper(CodeVal) = "0102"
>>?recno()
>>
>>It returns 581 (I have 580 records in this cursor). Why it's not working and not giving me the third record? I have SET EXACT OFF as well.
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
