>>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
>
>Excuse me for silly question. Did you check Send Sql Updates in View Designer?
Edward- I had checked it in the view designer at one point, and when it didn't work I had unchecked it. After changing the tableupdate syntax AND checking the send SQL updates box, it works. I had to change the tableupdate() to tableupdate(1) though, to commit changes to all records. Thanks again for your help.
Erik
Erik Moore
Clientelligence