Claude more info.
What is the type of
value,
field.
Do you have index?
How you check for
found?
>I have a form where I want to check if a value is already in the tabke. Because of what I am doing I check as get to next field (also want to check in save button). I use INDEXSEEK(value), SEEK(value), or LOCATE FOR field = value it always seens to return .T. (found the value) even when it is not in the table. If I do the same thing from the command window it works as expected.
>
>What am I missing?
>
>TIA
_______________________________________________________________
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