Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to detect any changes by another user.
Message
 
À
02/11/1999 16:34:23
Jason Mesches
Ocean Systems Engineering Corporation
Carlsbad, Californie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00285532
Message ID:
00286114
Vues:
20
>>From what I tried, I don't think so. I did the following:
>>
>>
>>USE MyView
>>Changed value of 5th field of 6 fields
>>? GETFLDSTATE(-1)     Returned 111121
>>? TABLEUPDATE(1)    Returned  .T.
>>? SEEK(%index expression%,'MyTable')    Returned .T.
>>? GETFLDSTATE(-1,'MyTable')    Returned  111111
>>
>>
>>Any other thoughts?
>>
>Check help on TABLEUPDATE() with .F. as a parameter. It will return not only whether the update failed, but where (and with AERROR(), why). Hope this helps!

Here is a scenario that could occur that has prompted this question in the first place:

Both User1 and User2 are modifying Product AAA.
User1 changes the Product Description (parent view)
User2 changes the Quantity of a line item and/or APPENDs a new line item and/or DELETEs a line item (child view)
User1 and User2 both issue TABLEUPDATE(0,'ParentView') and TABLEUPDATE(1,'ChildView')

Both users changes have now been saved to the base tables. This is what I'm trying to avoid. Any ideas?
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada

cmagee@metroland.com

Never mistake having a career with having a life.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform