Unable to create a trigger

[Daniele Bonfatti]

Hallo,
till now I have used the 7.3.0.25 sapdb software version, and I have had no problems in creating triggers.
Using the new 7.4.0.10 version I can not create them any more.
For example, when I try to create the trigger (by jdbc connection):

create trigger relation_insert for relation after insert execute
(
if customer_id = supplier_id and customer_id <> 0
then stop(-30000, 'Invalid relation in trigger: RELATION_INSERT');
);

the error thrown is:

Error: com.sap.dbtech.jdbc.exceptions.DatabaseException: [-5016] (at 187): Missing delimiter: ;

The 187th char is the ';' that ends the 'stop' statement.
Where is the problem?

Than you for any help, regards Daniele.

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general