David,
If you have buffering on the underlying tables can't you go ahead and do a tableudate to the view and not the underlying tables. This way you could do your summary query on the view and still have the capability to revert your changes before they are committed to the tables.
-myron kirby
myronk@flash.net
-------------------------------------------
>I've got an updateable parameterized view of child records, in a form with the DE of the view set to Optimistic Table Buffering. As they edit the rows and move from one row to another I want to update some summary information that appears on the bottom of the form. The edits have not yet been committed with tableupdate(), so they have an undo capability. But doing a
select sum( nQuantity ) from windowsedit into array laWindow doesn't ever show the effect of the current edits in the view.
>
>On the other hand good old fashioned scan code:
>
this.mnWindowCount = 0
>scan
> this.mnWindowCount = this.mnWindowCount + nQuantity
>endscan
>
>Works just great. Can someone explain me why?