Re: How to write this Trigger ?

Why don't you just use an after insert trigger NOT for each row?

--
Have a nice day
Michel

<wy_at_fudan.edu> a écrit dans le message : 7vpg9b$s8o$1_at_nnrp1.deja.com...
> I have a table t1.
> Create table t1(
> CostName Char(10),
> Cost Number(12,2) default 0,
> AllCost Number(12,2) default 0
> );
> I Want to use Trigger to set AllCost = sum(Cost) by CostName.
> I use "after insert for each row" and get mutating error!
>
> How to write this trigger!
> or some better ways to realise this function.
>
> eg:
> Insert 'abc',1
> the result 'abc',1,1
> insert 'abc',2
> the result 'abc',1,3
> 'abc',2,3
> insert 'abc',1
> the result 'abc',1,4
> 'abc',2,4
> 'abc',1,4
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Nov 03 1999 - 08:40:44 CST