7 is good value, 3(default) is not. 7 couldn't be default because value 4 was added later.
>It is local. The SET TABLEVALIDATE command was still completely unknown to me. I have now set it to 7 and the error is completely gone! Great.
>
>Is 7 a good value? I wonder why this isn't the default.
>
>>Is table local or on the network? What is in VFP9
>>
>>? SET("TABLEVALIDATE")
>>
>>
>>>I open a table shared in VFP9SP2 and do a successful FLOCK().
>>>
>>>I open the table shared in VFP7 with USE. It opens and is browseable. I close the table.
>>>
>>>I open the table shared in another session of VFP9SP2 with USE and get the error:
File is in use by another user.>>>
>>>What's going on here?
>>>
>>>Another scenario: I open the table shared in both vfp9 sessions. Then I do the FLOCK() in one of them. No errors.
--sb--