Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table Buffering, Detecting a Record Delete by Another Us
Message
From
17/09/1997 11:47:26
Glenn Mcburney
Doe(Ni) Information Systems Unit
Belfast, United Kingdom
 
 
To
17/09/1997 09:12:32
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00050289
Message ID:
00050405
Views:
26
>>>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..........
Glenn
DOE(NI), Belfast
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform