RE: trigger on update

Multiple triggers are allowed on a table, but a column can only be referenced on a single trigger. Use dbschema to view the current trigger and ensure the one you're creating does not reference those fields. -----Original Message----- From: jennifer_cai@my-deja.com [mailto:jennifer_cai@my-deja.com] Sent: Wednesday, July 05, 2000 1:15 PM To: informix-list@iiug.org Subject: trigger on update hi, I tried to create a trigger onUpdate. When there is an update on a table, the trigger will call a stored procedure. Bu I got "the same trigger event already exists" when trying to create it. Are multiple triggers allowed for Update on the same table? Thanx Jen Sent via Deja.com http://www.deja.com/ Before you buy. ------------------------------------------------------------------------------------------------------------ This e-mail is sent by a law firm and may contain information that is privileged or confidential. If you are not the intended recipient, please delete the e-mail and any attachments and notify us immediately.