Hi Craig
>This does not reliably work. The only reliable way to tell if a file is open exclusively is to try to USE it exclusively and then trap the error.
I have never used the function below to lock tables in VFP but it seemed to work in 2.6 all right. I confess I use it mainly for locking files other than tables. Could you provide a little more detail as to why it would not work. The only issue I can see is that another user could potentially grap the file before the current user gets to use it.
Thanks:)
>>Hello Alejandro
>>
>>This function works with any file not just a dbf.
>>
>>
>>
>> * Function returns true if file or table can be locked for writing
>> Func LOCKABLE
>> Lparam lcFile
>> Local lcRetval,liHandle
>> lcRetval=.f.
>> liHandle=fopen(lcFile,12)
>> If liHandle>0
>> lcRetval=.t.
>> =fclose(liHandle)
>> Endif
>> Return lcRetval
>>
>>
>>
>>
>
>
>This does not reliably work. The only reliable way to tell if a file is open exclusively is to try to USE it exclusively and then trap the error.