Based on your error, I recommend changing the Update Criteria of your view. Just open up the view in the view designer and go to the Update Criteria tab. Change the value of "SQL WHERE clause includes".
Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com