Re: Calculating Totals in Forms

From: tzadkiel <tzadkiel_at_surfnetcity.com.au>
Date: 1998/03/09
Message-ID: <01bd4b04$ce4ac180$85ce6ccb_at_default>#1/1


one or more of the fields are probably not defined as numeric. check their datatypes and use explicit to_number if you need it.

dave_at_potts-mullarkey.co.uk wrote in article <6dm2p0$fbn$1_at_nnrp1.dejanews.com>...
> I am trying to create a total field on a form, which is derived from the
> total of selected form records eg
> SMITH 2
> JONES 3
> JAMES 3
>
> TOTAL 8
>
> The form records are being generated from a query and the code to
 calculate
> the total is in a POST-QUERY trigger.
> Logic tells me that since the trigger fires for each record brought into
 the
> block I should be able to do something simple like:
>
> :form_total_field := :form_total_field + :individual_form_record_number
>
> This returns an error "to many declarations of + match this call"
>
> I have referred to all the Oracle help, and Lulushi, but the best I can
 find
> is a reference to the POST-QUERY trigger which states that it is commonly
> used for calculating running totals-but how??!!
> Any help on a most frustrating problem would be gratefully appreciated
>
> Dave Ingram
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
Received on Mon Mar 09 1998 - 00:00:00 CET

Original text of this message