----- Original Message ----- From: "Danny Tramnitzke" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 19, 2002 4:50 PM Subject: Errormessages on TRIGGER EVENT
> 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! > Much enigmatic and ambiguous in description language of the dbprocedures and trigger. Try so: drop Trigger abteilung_delete of street // Create Trigger abteilung_delete for Abteilung after delete execute ( var errorNo int; iNumParam int; errormess char(80); select count(*) from perso where perso.aptnr = :old.aptnr; fetch into :iNumParam; if iNumParam <> 0 then begin errorNo = 800; errormess = 'geht nicht, weil Fremdschlssel in Perso vorhanden'; stop (errorNo, errormess); end; ) // Pavel Konovalov ________________________________ JS RCOM, Russia http://www.rscom.ru _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
