>Thank you. But what do you do when you need to SEEK() on exact value?
>
SEEK already always work on the exact search pattern although you can control it with SET NEAR ON.
>>I generally set it off, then use == where I want an exact match
>>
>>
>>>Hi,
>>>
>>>I ran into a problem today that was caused by the fact that in one of the form's LOAD method there was SET EXACT ON. So I started checking further and found that a few other forms have SET EXACT ON in the LOAD. I am not going to ask why I put this code there <g> (who knows). But in general do you recommend never to have SET EXACT ON as global setting (in LOAD) and only set it ON in places where it is necessary and then reset it back to OFF?
>>>
>>>TIA.
If it's not broken, fix it until it is.
My Blog