George,

Try using TABLEUPDATE(). If it returns .F., use AERROR() to find out what went wrong.

>I keep getting an uncommitted changes error on a view in VFP 3.0,
>after I do a SQL update. I did something very similar on a separate form and didn't have a problem. Should I be using TABLEUPDATE?
>My table buffering on the form is set to optimistic. Any insights would be most helpful.