Hi Jim,

A possible reason for this is if you have the base table also open and buffered in the form then you would get this error as the base table would also need to be updated and not just the view.


>I have an application with a database that has several records. With the interface the user can scroll through the records. If the user changes an item on the screen, saves the information, scrolls one record back, then 1 record forward error #1545 - uncommitted changes occurrs. The error points to a view which updates its parent table when the information is saved. The tableUpdate(2) function is returning true when the information is saved for both the view and the parent table. I should also mention that there is not code that changes the view or the table. The error also occurrs on the
>requery() function in the refresh of the form.
>
>Any Ideas????
>I am completely stumped and any help would be greatly appreciated.
>
>Thanks
>
>Jim Rieck