Re: Totals with Oracle Forms

Elie Constantine wrote:

> Hi all,
>
> I have a form with 3 data blocks (A, B, C) joined in 2 master-child
> relationships in a way that A is the master of B, B is the master of
> C.
>
> I have special procedure to calculate the totals based on fields
> belonging to the C child table. When the user saves the changes I must
> update the result in a field belonging to the A master data block and
> the result must also be shown on the form.
>
> The 3 data blocks are database tables and the fields that are involved
> are database items.
>
> Which triggers can be used to execute the "Total Calculation and
> Update" code, and at which level? at the Form level, at A Data Block
> Level, B Data Block or C Data Block?
>
> Please note that I couldn't find an easy way to use the built-in
> "Calculation" Properties supplied by Oracle Forms to do the job
> because I have 2 relations and not 1.
>
> Thank you
> Elie,

[Quoted] How about the one that does the commit?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)