Hi all
Thomas (I guess) said in one mail, that only allowed to use NEW/OLD in
UPDATE-trigger, but the Trigger:
Create Trigger abteilung_delete for Abteilung after delete execute
(
var errorNo int;
iNumParam int;
errormess char(80);
select count(*) from dbadmin.perso where perso.aptnr =
:old.aptnr;
fetch into :iNumParam;
if iNumParam <> 0
then
begin
errorNo = 800;
errormess = 'geht nicht, weil Fremdschluessel in Perso
vorhanden';
stop (errorNo, errormess);
end ;
)
works fine. I get the right errormessage, when I delete an aptnr in
"Abteilung", which also stands in "perso".
So, what does that mean, it's only allowed in UPDATE-Trigger to use OLD/NEW
?
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
