Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to detect any changes by another user.
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How to detect any changes by another user.
Miscellaneous
Thread ID:
00285532
Message ID:
00285532
Views:
69
I have a parent - child form, for products, that is made from two views. The parent view (product) is buffered as Opt Rec and the child view (components) is buffered as Opt Table.

If a user modifies any part of a product I need to determine if the product has been changed in any way by another user. This would include changing any field in the product view record, changing any field in any of the component view records, an added component record, or a deleted component record. If any of these things have occurred I don't want to save the current users changes.

I'm pretty sure I can detect any modifications using CURVAL() and OLDVAL() on all fields but I'm definitely stumped on detecting an addition or deletion. Any ideas greatly appreciated.
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.
Next
Reply
Map
View

Click here to load this message in the networking platform