Hi all
This trigger-example seems to work, but I didn't get the defined
Error-Message (errormess).
When I delete a value in table "Abteilung", which is a foreign key I get
always the Message
"KB Stack op illegal".
Someone told me, that might be a kernel-error or something? What do you
mean?
Thats my Trigger, and I want see my own Errormessage, when I delete a row
in
Table "Abteilung" with a foreign key (aptnr).
drop trigger abteilung_delete of Abteilung
//
Create Trigger abteilung_delete for Abteilung after delete execute
(
var errorNo int;
errormess char(80);
if exists (
select * from perso
where perso.aptnr = old.aptnr
)
then
errorNo = 800;
errormess = 'geht nicht, weil Fremdschl�ssel in Perso vorhanden';
stop (errorNo, errormess);
)
Thanks for your efforts.
Danny
--
+++ GMX - Mail, Messaging & more http://www.gmx.net +++
NEU: Mit GMX ins Internet. Rund um die Uhr f�r 1 ct/ Min. surfen!
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
