Re: Power Objects: Subforms and Transactions

Tim Romano wrote:
>
> With Power Objects, is it possible to wrap a subform in a transaction, so
> that the set of rows inserted or updated by the subform could be rolled
> back in its entirety? E.g. the line items that are being written against
> an invoice header could remain uncommitted until their total dollar amount
> tallied with the amount on the invoice header.

With OPO, the boundaries of a transaction are a session. You can accomplish exactly what you want if you

• use two separate sessions
• make sure that you call the CommitWork() methods for each form separately, and don't call the CommitForm() for the parent form, which I believe would commit the transactions for both forms.

This topic is covered in depth in the forthcoming book "Mastering Oracle Power Objects", from O'Reilly and Associates, by yours truly and Bob Hoskin. Lots of stuff on V2 also. Received on Fri Oct 11 1996 - 00:00:00 CEST