>>>>In VFP5 how do I detect if another user has deleted the current record when table buffering is used?
>>>
>>>GETFLDSTATE(cFieldName | nFieldNumber [, cTableAlias | nWorkArea])
>>>
>>>Returns Numeric
>>>
>>
>>Thanks for your reply.
>>
>>I played with this function and it appears that it only works on records that I have deleted. I want to know if another user has deleted it.
>
>Just a few thoughts.....
> GetFldState should work on the table therefore applies to all users. (but I have had problems with it in the past)
> If the record in question was marked for delete than recalled it will still show up as status changed.
> If the first number is returned as 2 then it could have been triggered by a edit also.
> Deleted() could be used.
>Correct me if anyone disagrees..........

I have run test after test with two sessions of foxpro and GetFldState returns values based on the edits made in the current session only. Does any one have a reliable way to check the deletion status from disk when a table has record buffering enabled? Curval() returns the value of a field from disk, there should be some way to return deletion status from disk.