Hi all-
Started using views just recently. I have a candidate key ( it wouldnt let me build a primary key becuase I use free tables, not a database container)and all fields except candidate key are selected as updateable. I have "Send SQL updates" checked and the table that I'm using for the view is has table buffering set to 1. (I had heard that when I tableupdate, to make sure that the table is not buffered when using a view to update- as good advice) In my form, I have the view in the data environment, and all controlsources of my txtboxes set to the view.fieldnames. Under a "save" button I call tableupdate(0). When I try to move to the next record, I get the 1545 error -Table buffer for Alias "Viewname" contains uncommited changes. Im not sure why, because before I select "Next", I "Save" the changes.

So, in my "Save" button click event, I have added REPLACE commands to replace the View.fieldnames with thisform.txtboxs.values.
After the series of REPLACE commands, I tableupdate(0) and it doesnt give me the error anymore.

I didnt think that I would have to use the REPLACE command when I have the txtboxes controlsourced to the view.

Am I going about this all wrong?



Thanks in advance for all your help!
Angie