I have a classic order header/detail form. I have a parent bus object and a child business object with many items. In order to be able to cancel any item additions I have set the child view to be table buffered.

Now, what I need to do is scan the child view and calculate an amount for groups (this is necessary) of rows and and then total them for the entire order at the time of saving the header.

I tried this using a select statement with a group by clause in the presavehook. This would work fine, however, the select statement does not return the uncommitted changes made to the child business object.

Does anybody know if there is there a way to use the select statement on the view and select all rows with the uncommitted changes? Or is there another command I can use.

(I know I can issue a save to the business object first, then run my select and issue another save, but I do not want to do it this way if there is another way to read uncommitted changes.)

Thanks for any help.