>>What does TABLEUPDATE() return? Are you sure you are not double buffered? (Copy of base table open and buffered in the same DS).
>
>Thanks for responding.
>
>What had happened was that the next primary key value I was retrieving was not unique, causing the TABLEUPDATE() to fail. As soon as I made sure I was getting unique value for the primary key it worked fine.
>
>But I'm wondering why VFP didn't give me the unique violation error message.
>

When using TABLEUPDATE with a view, it's a good idea to make it a habit of always checking the return value, and doing something in case it fails. My framework's Save method wraps the TABLEUPDATE function with a check that handles failures.