RE:trigger on update

Thanks for your help. Yes,there is already an update trigger on this table that doesn't declare any columns. So i cannot create another update trigger for a specified column of this table? Is there any other way to do this? In article <39638194.0@pretorian>, "Stephen Faehn" <steve_faehn@nospam.com> wrote: > According to the SQL manual for Informix : > "Multiple update triggers on a table cannot include the same columns." > > So yes, you can have multiple triggers, but one must specify different > columns in each create trigger statement. > Maybe you aleady have defined a trigger that doesn't declare the columns > ..ie in "CREATE TRIGGER trig UPDATE ON table REFERENCING ..... > Look at the table schema to verify this. > > Good luck ......! > <jennifer_cai@my-deja.com> wrote in message > news:8jvqne$8iv$1@nnrp2.deja.com... > > hi, > > I tried to create a Informix trigger on Update. > > When there is a update on a table, my trigger > > will call a strored procedure. But I got > > "the same trigger event already exists" when I > > tried to create the trigger. > > Are multiple triggers allowed on Updating the same > > table? > > > > Thanks > > > > Jen > > > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > > Sent via Deja.com http://www.deja.com/ Before you buy.

The original trigger can execute multiple SPLs or the SPL it is running now (if any) can also call the new one. Art S. Kagel jennifer_cai@my-deja.com wrote: > > Thanks for your help. > Yes,there is already an update trigger on this table that doesn't > declare any columns. So i cannot create another update trigger for > a specified column of this table? > Is there any other way to do this? > > In article <39638194.0@pretorian>, > "Stephen Faehn" <steve_faehn@nospam.com> wrote: > > According to the SQL manual for Informix : > > "Multiple update triggers on a table cannot include the same columns." > > > > So yes, you can have multiple triggers, but one must specify > different > > columns in each create trigger statement. > > Maybe you aleady have defined a trigger that doesn't declare the > columns > > ..ie in "CREATE TRIGGER trig UPDATE ON table REFERENCING ..... > > Look at the table schema to verify this. > > > > Good luck ......! > > <jennifer_cai@my-deja.com> wrote in message > > news:8jvqne$8iv$1@nnrp2.deja.com... > > > hi, > > > I tried to create a Informix trigger on Update. > > > When there is a update on a table, my trigger > > > will call a strored procedure. But I got > > > "the same trigger event already exists" when I > > > tried to create the trigger. > > > Are multiple triggers allowed on Updating the same > > > table? > > > > > > Thanks > > > > > > Jen > > > > > > > > > Sent via Deja.com http://www.deja.com/ > > > Before you buy. > > > > > > Sent via Deja.com http://www.deja.com/ > Before you buy.