Re: Disbale Trigger?

Posted in 2003

Tsutomu Ogiwara — Thu, 15 May 2003 17:17:31 +0900 — source: Usenet: comp.databases.informix

Hi. set triggers for <table_name> enabled. HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: aljubicic <member22907@dbforums.com> >Reply-To: aljubicic <member22907@dbforums.com> >To: informix-list@iiug.org >Subject: Disbale Trigger? >Date: Thu, 15 May 2003 04:37:27 +0000 > >Hi All, > >Could anyone help me on how to disable a trigger on a Informix Dynamic >Server Database. I am writing a Visual Basic Application however I need >the Application to disable an Insert and Update trigger when it writes >to this table. In MS SQL 7, I can disable a trigger using "ALTER TABLE", >is there anything in Informix that can do the same thing or would I need >to drop it and recreate it each time?? > >Thanks >Anthony > >-- >Posted via http://dbforums.com _________________________________________________________________ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail