Hi all
I have a question about the $rc variable in trigger.
What is the maximun value of that $rc in a STOP-statement, because in my
trial I get always the same errormessage ("KB Stack op illegal").
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
