>Why cant I RLOCK the parent record?
>By the way, I DO use tableupdate() (inside a transaction) when the user clicks SAVE.. the problem is that it it doesn't run through my save method because only the sibling (not the InitialSelectedAlias) is getting committed.
I had a similar problem with optimistic row buffering and accessing the menu while adding/editing. This caused a TABLEUPDATE to occur automatically. I changed it to optimistic table and now all is fine. Maybe something similar is happening when you change work areas or run the SQL.
Also, there is nothing wrong with using RLOCK(). I use it all the time. When a user chooses to modify a record in my apps I have method code like:
IF RLOCK()
Enable fields to allow editing
ELSE
Show message "Record is being modified by another user"
ENDIF
Buffering alone does not handle this. HTH
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.