You can alway have code in the trigger look for value to allow the code to continue. It can be a table with a value.
Dan Goldberg Dan Goldberg -------- Original message -------- From: rehan wyne <[email protected]> Date: 11/23/2014 10:17 AM (GMT-08:00) To: RBASE-L Mailing List <[email protected]> Subject: [RBASE-L] - Re: How to disable Database triggers Thanks Albert and Razzak. I am also using the same method as described by Albert. I have two script files, one to add triggers to a table and otherone to drop triggers from a table. But as described by Razzak, it is good to know that 9.5 has this option in data designer. Regards Rehan Wyne MIT On Sunday, November 23, 2014 10:38 PM, A. Razzak Memon <[email protected]> wrote: At 11:44 AM 11/23/2014, Rehan Wyne wrote: >Is there any command available in R:Base to disable / enable >database triggers? >I am unable to find any command in help. Rehan, Using R:BASE eXtreme 9.5 (32/64) for Windows, actually there are two options to Enable/Disable Triggers. 01. Using Data Designer (RBDefine): Database Explorer | Tables | Design Table ... Notice a whole new Group for [Triggers] including options to [ ] Execute Trigger . Before Insert . After Insert . Before Update . After Update . Before Delete . After Delete Clicking on the [ ] Execute check box will Enable/Disable the execution of defined Trigger(s) accordingly. 02. Alternatively, you could use the CREATE TABLE and ALTER TABLE commands to Create, and Enable/Disable Triggers. Hope that helps! Very Best R:egards, Razzak www.rbase.com www.facebook.com/rbase -- 31 years of continuous innovation! 16 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
