Re: Trigger help.

umm, ok, so what is a 'stored procedure/function' and how is it implemented?

thanks again...

--
tj madigan
e-mail: madigan_at_mscs.mu.edu
http://studsys.mscs.mu.edu/~madigan

On Fri, 6 Feb 1998, Patrick Flahan wrote:



> A mutating error occurs when you try to modify the same table as the one

> that the trigger belongs to.  This type of action could lead to severe

> problems.  Let's say you insert one group of rows, and then the trigger is

> performed. You then have an insert in the trigger which is performed which

> then calls the same trigger which tries to insert, and so on.

> 

> I would say the best way to implement this type of action would be with a

> stored procedure/function.   You could have the function perform the inserts

> and the running totals(?) and then insert the final line.

> 

> Hope this helps.

> Patrick Flahan

> flahan_at_leading.net

>