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 WyneMIT
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!
--
