I recently saw some unusual behavior I cannot explain.

I have a form which works on four different views of a single table. Optimistic table data buffering is set on for all four views.

When a change was made to one particular view the data buffering did not work. That is the oldval() function returned the new value. When I left the form I got cursor contains uncommitted changes errors. Data buffering worked for the other three views.

I discovered that I had a bound combo box control whose init method contained a this.Value = "something" statement, when "Something" was not an allowed choice. In other words I was changing the data in the opening record of the view when I opened the form. When I removed the statement the data buffering worked as it should.

My question is why did the fact I had an uncommitted change to a view prevent the data buffering from working? Do I have yet another problem?