Thanks Burkhard, now it works! But is there the possibility to write the Trigger in more than ONE row, because then it's more clear to programm Trigger in a sql-file.. (also to create big tables and such stuff...)
Danny > >-----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 > -- +++ 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
