Sorry, i didn't knew how to express myself.

What i'm trying to ask is why a sql statement like 'select master.status
from master where master.id = detail.id_master' return NULL when inside an
after delete trigger of a table that is being deleted by a cascade delete
FK?

----- Original Message -----
From: "Raymond Kennington" <progsol@...>
To: <ib-support@yahoogroups.com>
Sent: Wednesday, February 05, 2003 12:38 PM
Subject: Re: [ib-support] Trigger Order (correct question)


> Valdir Stiebe Junior wrote:
> >
> > The order in this case shouldn't be (this is a question, not an
affirmative
> > sentence)
>
> [It's always easier to answer a question asked in the positive and one
that has
> a question mark.]
>
> > 1.before delete MASTER
> Deletes all details
> > 2.before delete DETAILS
> deletes details
> >No 3.delete DETAILS
> >No 4.after delete DETAILS
> >No 5.delete MASTER
> >No 6.after delete MASTER?????
>
> --
> Raymond Kennington
> Programming Solutions
> W2W Team B
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>