>>>The View has the new record in it, but the base tables does not.
>>>If I REQUERY("ViewA"), I get the error "Table buffer for alias "ViewA" contains uncommited changes." Any ideas?
>>>
>
>I'm Using the View Designer. From the Update Criteria Tab, I selected the table. I then set the the primary key in a field called "DNIS". Then I pressed the Update All button, checked the Send SQL Updates chckbox, and selected the key and selected the "Key and Update Fields" radio button.
Ed,
The error message indicates that the TableUpdate never completed successfully, or that there was more than one record buffered in the view. You can change the first agrument of the tableUpdate function to 1 (from 0) and then mdoify your code so it shows you whether the tableupdate succeeded or failed.
If find that the tableupdate is failing you can use AERROR() to find out what went wrong.