>Let's say I do the followings:
>- open an instance of Visual FoxPro
>- create a table "tabtest" and enter some data
>- issue a FLOCK() on that table
>- perform: "SELECT * FROM tabtest" and I get the data
> Everything's OK so far.
>
>If I open another instance of Visual FoxPro (the previous instance is still opened) and try the same query: "SELECT * FROM tabtest" I get the error message that the file is in use by another user. (SET EXCLUSIVE is OFF in both of the situations)
>Can someone, please, explain to me this type of behaviour because in FPD 2.6, in the same situations, I was able to run that query.
>
>Thanks

I expect it's because it's doing exactly as it says on the tin - performing a file lock, such that another user cannot access the table.