>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.

Thanks.
I'm glad to know that you're there to help. :)