LOCATE command is not affected by SET NEAR ON. Only FIND and SEEK are affected.
>Hi everybody,
>
>Just discovered a fact, which surprised me a little.
>set exact off
>set near on
>LOCATE FOR Fullname='Banknorth'
>
>Record position is in the end of the file (there is no Banknorth)
>set order to fullname
>seek 'Banknorth'
>record position is on the next record "Bann Cor Mortgage ", which is where I want it to be...
>
>Could you please explain me this difference.
>
>VFP6 SP4.
--sb--