SE7.23: trigger have only to fire ones

Posted in 2000

Topics: Installation, Setup & Upgrades, Triggers, Constraints & Referential Integrity

Peter — Wed, 07 Jun 2000 11:55:30 GMT — source: Informix-list mailing list archive (1991-1998)

Hi, i have to install a trigger in a table A witch has only to fire ones. If executed first time (insert/update or delete, anyway) it must deactivate itself, or better remove itself. How can i do that? Thanks a lot Peter

↪ replying to Peter

Chris Brauer — Thu, 08 Jun 2000 10:04:34 +0200 — source: Informix-list mailing list archive (1991-1998)

I don't know why to create a trigger for this purpose, but anyway: SET TRIGGERS FOR table DISABLED called by a script called by your stored procedure via 'SYSTEM' Maybe this one should do it. Bye, Chris Peter schrieb: > Hi, > i have to install a trigger in a table A witch has only to fire ones. > If executed first time (insert/update or delete, anyway) it must > deactivate itself, or better remove itself. > How can i do that? > Thanks a lot > Peter