Need workaround for constraint violation on triggers...

Posted in 1998

Ted Haasl-Martinez — Wed, 22 Jul 1998 13:05:14 -0700 — source: Informix-list mailing list archive (1991-1998)

I have a set of cascading triggers, where I need to update the triggering table. Issue: The engine won't allow the update to the triggering table, with the SQL Error -747 I NEED to use a FOR EACH ROW as opposed to using an AFTER statement, to pass parameters, each row, etc. Any ideas? -- Ted Haasl-Martinez / Database Admin Support / HEWLETT PACKARD / CIM Engineering /_ __ Telnet: 212-3080 / // / Email: tedm@vcd.hp.com / //_/ Smail: 18110 SE 34th St, Vancouver WA,98683 /

Related threads

insert trigger/stored procedure
Client/Server Application Developers Needed In Singapore