Sergey, thank you. I have added the command to my nicesettings.prg with a comment to this thread. :)
It is my impression that 4 was added to correct a design flaw.
>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.
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.
