Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table Buffering, Detecting a Record Delete by Another Us
Message
 
À
18/09/1997 05:09:52
Glenn Mcburney
Doe(Ni) Information Systems Unit
Belfast, Royaume Uni
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00050289
Message ID:
00050675
Vues:
33
>>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform