hi, there's a funny thing about those if statements: if it contains only one statement and it's followed by statement that doesn't need to separated by a token, the parser throws funny error statements.
just try removing the semicolon at position 187. John Holland Consultant BANCOTEC Ein Unternehmen der Cellent AG. Calwer Strasse 33, 70173 Stuttgart Tel: ++49 711 222 992 900 Fax: ++49 711 222 992 999 Mobile: ++49 172 7886719 mailto:[EMAIL PROTECTED] http:\\www.bancotec.de http:\\www.cellent.de "Daniele Bonfatti" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:<[EMAIL PROTECTED]>... > 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
