>CREATE TRIGGER "MYTRIGGER" FOR MYTEST AFTER INSERT EXECUTE ( > UPDATE "TEST"."MYTEST" > SET id = (SELECT ID_GEN.NextVal FROM DUAL) > WHERE id = 0; >) But isn't it the SAPDB syntax? I wanted to use the Oracle code in oracle mode. The documentation says not much about, only that oracle-after-like trigger definitions are allowed.... >Please note, that you don't need the select expression in the >update statement >and that you should check the return code : thanks, i will remember that later.. bye! _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
