>>>Hello All [ I hope you all haven't gone to Devcon ],
>>>I have a form which contains a grid bound to a view, if I run the form directly i.e. do form myform, I can add and delete records to my hearts content and the underlying table gets updated. However if I call the form from another form the underlying table does not get updated. I use these settings on both forms: Default Datasession, view buffering set to Optimistic Table and the form buffering set to Optimistic. The view is used by both forms, I've tried creating a new view for the called form but the problem persists, what am I doing wrong?.
>>>
>>>TIA
>>>
>>Hi Pete,
>>
>>Are you sure that both forms have buffering on the view's underlying table? It sounds as if the form that's being called has buffering set to none, with the underlying table using the form's buffer mode, and the view's set to optimistic table. When this form is called from the other form, you have both the table and the view buffered. This would mean that you'd have to commit your changes to both the view and then the table. Make sense?
>
>Hello Both,
>you were both right, all is well, I discovered the underlying table was also in the DE ( in a position off the screen ) and also buffered, when I went over from tables to views I must of forgotten to remove it, so although the view was doing its job updating the table the changes were never commited.
>
>Doh !
>
Hi Pete,

Don't be too hard on yourself. I think that this problem is part of a "right of passage" when using views. In short, I think most of us have done this at one time or another (at least I have), and almost gone crazy trying to figure out what's going on.