Hi, I'd like to see the ability to write triggers that execute when the transaction commits. The specific triggers would still be associated with insert, update, and delete so you'd write code like:
CREATE TRIGGER foo_update FOR foo AFTER INSERT_COMMIT ... This would allow referential integrity to be encoded into the database in those cases where the business rules are mutually dependant. An example: A customer must have at least one address, but an address can't exist without a customer. The current trigger design cannot enforce both rules. I'm not on the sapdb.general list, so please cc me if you wish further discussion. Thanks. Karl <[EMAIL PROTECTED]> _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
