Yes, but how can I pass a reference of the row just inserted to the
trigger??
adb wrote:
>
> Sounds like you need to use a trigger set to
> fire after the insert on table A
>
> Alex.
>
> On Tue, 30 Jan 2001, Nelio Alves Pereira Filho wrote:
>
> > I read at the docs that rules are executed before the query that
> > generated them. Is there any way to change this?
> >
> > Here's my problem: I have two tables, A and B, and after an INSERT on
> > table A, I want to update an specific field on table B, with the result
> > of a sum in A. To do this I needed some information about the row just
> > inserted, so I used rules. As my sum is running before the insertion,
> > its result is wrong.
> >
> > Any ideas?
> >
> > Tks
> >
> > --
> > Nelio Alves Pereira Filho
> > IFX Networks - www.ifx.com.br
> > +55 11 3365-5863
> > nelio@ifx.com.br
> >
--
Nelio Alves Pereira Filho
IFX Networks - www.ifx.com.br
+55 11 3365-5863
nelio@ifx.com.br