--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 09:20 PM 3/10/2004 -0300, you wrote:
>
>
> It is also wrong. Assuming this is a BeforeDelete trigger on

BOMBAS, your

> trigger will all deletions to any records from this table if *any*

record

> in despachado has a matching record in bombas..
>

Is strange, but dont do that. If i select a record in BOMBAS not
having IDBOMBAS value in DESPACHADO it delete,but if i select one
having a value in despachado it raises exception.

> What you *really* want to do is test whether there are any records

in

> despachado that are dependent on the CURRENT record:
>
> create trigger bd_bombas for bombas
> active before delete
> as
> begin
> if (exists (select 1 from despachado
> where idbomba = OLD.idbomba)) then
> exception ex_despachado_bomba;
> end
>

I will try that.

> Hint: you will also need Before Insert and Before Update triggers

on

> DESPACHADO to restrict despachado.idbomba to values that exist in

BOMBAS.

>

Uf, a lot of stuff... I really like foreign keys.

German.