Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table Buffering, Detecting a Record Delete by Another Us
Message
 
To
18/09/1997 05:09:52
Glenn Mcburney
Doe(Ni) Information Systems Unit
Belfast, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00050289
Message ID:
00050675
Views:
28
>>Dan, I haven't tried this, but you could load 2 copies of the table in question. The first is used for editing. When you wish to check the delete status, USE MyTable AGAIN... and check the record in question with DELETED(). Slow, but accurate as of the time you do the USE...AGAIN command.
>>
>>Interesting problem...
>>
>>Barbara
>
>My curiosity was aroused.....
>I added two buttons to an existing form one to check GETFLDSTATE the other DELETED(), ran two sessions of this form, navigated to the same record on both and deleted the record with one of them.
>When the buttons were clicked on the other form deletion status was 1 (unchanged) and was not marked for deletion (returned .f.)
>I think this confirms what Dan has been saying. (BTW buffermode=2, datasession=1)

Dan, GetFldState(-1) will only check if the Delete status was changed on your machine, true. However, I think you'll get the right results checking Deleted() if you re-use your data before checking. Remember that the form is checking what's in memory, not what's been changed on the server. That's why I suggested that Dan fire off a "USE AGAIN" at the moment he wanted to check the data.

Barbara
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform