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?