Re: Triggers

Obnoxio The Chav wrote: > tomcaml@yahoo.com said: > >>We are on Infx 9.40 FC3. >>Does anyone know if there are plans for a future version to implement >>multiple triggers per table? > > What do you mean by multiple triggers? The ability to add (for example) several separate update triggers on a single table, rather than having to work out what the current trigger actions are, drop the trigger, and then recreate a new trigger with your extra action(s) added to it. Ignoring REFERENCING clauses: CREATE TRIGGER t_update1 UPDATE ON TablenameFOR EACH ROW (EXECUTE PROCEDURE decapitation(...)); CREATE TRIGGER t_update2 UPDATE ON TablenameFOR EACH ROW (EXECUTE PROCEDURE reassembly(...)); vs CREATE TRIGGER t_update1 UPDATE ON TablenameFOR EACH ROW (EXECUTE PROCEDURE decapitation(...)); DROP TRIGGER t_update1; CREATE TRIGGER t_update1 UPDATE ON Tablename FOR EACH ROW (EXECUTE PROCEDURE decapitation(...), EXECUTE PROCEDURE reassembly(...)); It's a not unreasonable request - we are looking at it. No promises about delivery date. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/