Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to detect any changes by another user.
Message
 
To
02/11/1999 16:34:23
Jason Mesches
Ocean Systems Engineering Corporation
Carlsbad, California, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00285532
Message ID:
00286114
Views:
21
>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform