Daniele Bonfatti wrote : >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? The problem ist the ';' following the ')', but that's the same with 7.3.0.25. Regards, Thomas -- Thomas Anhaus SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
