I use parameterized views in many of my forms but only just recently was confronted with the need to have one of them updateable. The form is a one to many form with parent information on the first page of a pageframe and a grid with child information on the second. In page2's page.activate, I set the view's paramter, and requery, and then refresh the grid. This works fine. What doesnt work is the updateable part. (the fields have been specified as updateable in the view designer). In the second page's deactivate event is a TABLEUPDATE(). When after updatinga field and switching to the first page, and then switching back, I get an error on the REQUERY line of page2.activate:"Table buffer for alias 'myviewname' contains uncommitted changes" So I changed the code in page2.deactivate to read tableupdate(1, .T. 'myviewname'). No difference. So I tried
SELECT myviewname
TABLEUPDATE()
No change. How do I commit changes to the view?
Thanks
Erik Moore
Clientelligence