Re: Calculating Totals in Forms
Date: 1998/03/07
Message-ID: <6ds0q4$hpf_at_info.csufresno.edu>#1/1
> :form_total_field := :form_total_field + :individual_form_record_number
> This returns an error "to many declarations of + match this call"
The "too many declarations" it is probably because one of the items, either :form_total_field or :individual_form_record_number is not defined as a number. It has nothing to do with the post-query trigger except that you have tried to perform the invalid arithmetic in that trigger. Don't you wish Oracle would improve some of their pl/sql error messages--like this one?
Steve Cosner
http://members.aol.com/stevec5088
Downloadable utility form -- Display and update any table.
In article <6dm2p0$fbn$1_at_nnrp1.dejanews.com>,
<dave_at_potts-mullarkey.co.uk> wrote:
>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
Received on Sat Mar 07 1998 - 00:00:00 CET