Good Morning all
I want to create Trigger with a sql-file and xsql, but there comes an error,
when the Triggercreation starts.
The sql-file has the following content:
select * from perso
drop table Hallo
create table Hallo(nr smallint, name char(50))
insert into Hallo values (1, 'hello')
select * from Hallo
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.'))
all the selections and Tablecreations work, but not the Trigger.
Errormessage
* -3014: Invalid end of SQL statement
comes, though the Trigger is in ONE line written.
So whats the problem here?
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
