>>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.comNever mistake having a career with having a life.