Simple trigger question

I need to set 2 trigger actions for updates of my inventory table. One when the table goes from 1 to 0 and a different one for when the table goes from 0 to 1. Do I create 2 different triggers, or do I create one trigger with 2 when statements?

2009/7/15 JaxenT <jaxen@dzm.com>: > I need to set 2 trigger actions for updates of my inventory table. > One when the table goes from 1 to 0 and a different one for when the > table goes from 0 to 1.   Do I create 2 different triggers, or do I > create one trigger with 2 when statements? > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > Jaxen You don't specify which version of IDS, however, certainly at older versions, it is only possible to specify a single trigger for each of the INSERT, UPDATE or DELETE actions, therefore one trigger with 2 WHEN statements. Keith

IBM Informix Dynamic Server Version 11.50.UC1E > > You don't specify which version of IDS, however, certainly at older > versions, it is only possible to specify a single trigger for each of > the INSERT, UPDATE or DELETE actions, therefore one trigger with 2 > WHEN statements. > > Keith