Re: Sum of Details on Master

From: Jeff Jacobs <jmjacobs_at_ix.netcom.com>
Date: 1997/04/14
Message-ID: <33558c29.32383818@nntp.ix.netcom.com>#1/1

nbroucke_at_be.oracle.com (Nico Vandenbroucke) wrote:

>Any1 who knows how to handle this problem?
>
>The database holds two tables ('INVOICE' (master) and 'INVOICELINE' (detail)).
>Every Invoice line has an amount.
>
>We would like to keep the total amount of the invoice lines in the Invoice
>table.
>
>We've been thinking about some databasetriggers on Invoice line,
>but how can we handle this in Forms 4.5 ?
>
>We know that designer/2000 allows the generation of a sum field, but I believe
>the generator then generates a non-database field.
>

The generator does create a NBT item, but its *very* easy to hack the code to load the invoice total column instead. (This is exactly what we do in one of the lab exercises in our "Using Designer/2000 Generators" course). -JJ

Jeffrey Jacobs & Associates
Oracle Designer/2000 Consulting & Training 951-2 Old County Road, Suite 119, Belmont, CA 94002 Voice: 415-571-7092, FAX: 800-665-1379 CompuServe: 76702,456 Internet: jmjacobs_at_ix.netcom.com Received on Mon Apr 14 1997 - 00:00:00 CDT