>-----Original Message-----
>From: Danny Tramnitzke [mailto:[EMAIL PROTECTED]]
>
>I want to create Trigger with a sql-file and xsql, but there comes an error,
>when the Triggercreation starts.
<cut>
<create trigger testtri of perso after delete execute (if exists (select *
<from Hallo where nr = old.aptnr) then stop (30001, 'Cannot delete perso,
<because Hallo exists.'))
Hi,
the syntax of your create trigger command is wrong.
Please try it with
create trigger testtri for perso after delete execute (if exists (select *
^^^
from Hallo where nr = old.aptnr) then stop (30001, 'Cannot delete perso,
because Hallo exists.');)
^
regards,
Burkhard
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
