Subject Re: On Update/Delete Cascade
Author Adam
--- In firebird-support@yahoogroups.com, "Cipto" <cipto.kh@g...> wrote:
> I want to know how Firebird 1.5.2 doing this job for every table
that has a foreign key on update cascade or on delete cascade to
master table.
>
> I mean what is the rule that Firebird will follow to make it cascade,
> Is it doing randomly in every table that has dependency to the
master table or it has some update/delete cascade rule??
>
> TIA
>
> [Non-text portions of this message have been removed]

From memory it uses the same mechanism as a trigger to implement the
on update and on delete behaviour. It fires when the update or delete
happens on the master record, but I am not quite sure of your question
about if it is doing it randomly? Perhaps you could explain what you
are trying to work out.

Adam