Trigger with SE 6.0
Hello,
I have some problems with trigger.
When I create this trigger, the Database Server terminats.
WHY????????????????????????????
----------------------------------------------------------------------------
----------------------------------------------------------------------------
-----------------
create trigger tU_Ricorso_Socio UPDATE on Ricorso_Socio
referencing NEW as inserted OLD as deleted
for each row
when(
deleted.med_nome <> inserted.med_nome or
deleted.med_cognome <> inserted.med_cognome or
deleted.med_dataNascita <> inserted.med_dataNascita or
deleted.riv_nome <> inserted.riv_nome
)
(update Quota_RIcorso
set
Quota_RIcorso.med_nome = inserted.med_nome,
Quota_RIcorso.med_cognome = inserted.med_cognome,
Quota_RIcorso.med_dataNascita = inserted.med_dataNascita,
Quota_RIcorso.riv_nome = inserted.riv_nome
where
Quota_RIcorso.med_nome = deleted.med_nome and
Quota_RIcorso.med_cognome = deleted.med_cognome and
Quota_RIcorso.med_dataNascita = deleted.med_dataNascita and
Quota_RIcorso.riv_nome = deleted.riv_nome
),
when (
not exists (
select * from Ricorso
where
inserted.riv_nome = Ricorso.ric_nome
)
)
(execute procedure erwin_raise_except(
-746,
'Cannot UPDATE "Ricorso_Socio" because "Ricorso" does not exist.'
)),
when (
not exists (
select * from Socio
where
inserted.med_nome = Socio.med_nome and
inserted.med_cognome = Socio.med_cognome and
inserted.med_dataNascita = Socio.med_dataNascita
)
)
(execute procedure erwin_raise_except(
-746,
'Cannot UPDATE "Ricorso_Socio" because "Socio" does not exist.'
))
[INTERSOLV][ODBC Informix driver][Informix]Database server terminated
unexpectedly.
Execution Failed
----------------------------------------------------------------------------
----------------------------------------------------------------------------
-----------------
I need some help, please.
Leonardo