Subject Re: [firebird-support] How to remove source code of triggers
Author Wei Yu
Try to execute this UPDATE RDB$TRIGGERS SET RDB$TRIGGER_SOURCE = NULL; but failed:

Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.
action cancelled by trigger (0) to preserve data integrity.
cannot modify or erase a system trigger.


William, Yu


----- Original Message ----
From: Wei Yu <william_yuwei@...>
To: firebird-support@yahoogroups.com
Sent: Thursday, August 9, 2007 11:37:38 AM
Subject: Re: [firebird-support] How to remove source code of triggers













Thanks!



William, Yu



----- Original Message ----

From: Martijn Tonies <m.tonies@upscene. com>

To: firebird-support@ yahoogroups. com

Sent: Thursday, August 9, 2007 9:45:05 AM

Subject: Re: [firebird-support] How to remove source code of triggers



Hi,



> Is there anyway to remove source codes of triggers?



Update RDB$TRIGGERS set RDB$TRIGGER_ SOURCE = '';



Martijn Tonies



Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &



MS SQL Server



Upscene Productions



http://www.upscene. com



My thoughts:



http://blog. upscene.com/ martijn/



Database development questions? Check the forum!



http://www.database developmentforum .com



<!--



#ygrp-mlmsg {font-size:13px; font-family: arial, helvetica, clean, sans-serif;}

#ygrp-mlmsg table {font-size:inherit; font:100% ;}

#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;}

#ygrp-mlmsg pre, code {font:115% monospace;}

#ygrp-mlmsg * {line-height: 1.22em;}

#ygrp-text{

font-family: Georgia;

}

#ygrp-text p{

margin:0 0 1em 0;}

#ygrp-tpmsgs{

font-family: Arial;

clear:both;}

#ygrp-vitnav{

padding-top: 10px;font- family:Verdana; font-size: 77%;margin: 0;}

#ygrp-vitnav a{

padding:0 1px;}

#ygrp-actbar{

clear:both;margin: 25px 0;white-space: nowrap;color: #666;text- align:right; }

#ygrp-actbar .left{

float:left;white- space:nowrap; }

.bld{font-weight: bold;}

#ygrp-grft{

font-family: Verdana;font- size:77%; padding:15px 0;}

#ygrp-ft{

font-family: verdana;font- size:77%; border-top: 1px solid #666;

padding:5px 0;

}

#ygrp-mlmsg #logo{

padding-bottom: 10px;}



#ygrp-vital{

background-color: #e0ecee;margin- bottom:20px; padding:2px 0 8px 8px;}

#ygrp-vital #vithd{

font-size:77% ;font-family: Verdana;font- weight:bold; color:#333; text-transform: uppercase; }

#ygrp-vital ul{

padding:0;margin: 2px 0;}

#ygrp-vital ul li{

list-style-type: none;clear: both;border: 1px solid #e0ecee;

}

#ygrp-vital ul li .ct{

font-weight: bold;color: #ff7900;float: right;width: 2em;text- align:right; padding-right: .5em;}

#ygrp-vital ul li .cat{

font-weight: bold;}

#ygrp-vital a {

text-decoration: none;}



#ygrp-vital a:hover{

text-decoration: underline; }



#ygrp-sponsor #hd{

color:#999;font- size:77%; }

#ygrp-sponsor #ov{

padding:6px 13px;background- color:#e0ecee; margin-bottom: 20px;}

#ygrp-sponsor #ov ul{

padding:0 0 0 8px;margin:0; }

#ygrp-sponsor #ov li{

list-style-type: square;padding: 6px 0;font-size: 77%;}

#ygrp-sponsor #ov li a{

text-decoration: none;font- size:130% ;}

#ygrp-sponsor #nc {

background-color: #eee;margin- bottom:20px; padding:0 8px;}

#ygrp-sponsor .ad{

padding:8px 0;}

#ygrp-sponsor .ad #hd1{

font-family: Arial;font- weight:bold; color:#628c2a; font-size: 100%;line- height:122% ;}

#ygrp-sponsor .ad a{

text-decoration: none;}

#ygrp-sponsor .ad a:hover{

text-decoration: underline; }

#ygrp-sponsor .ad p{

margin:0;}

o {font-size:0; }

.MsoNormal {

margin:0 0 0 0;}

#ygrp-text tt{

font-size:120% ;}

blockquote{margin: 0 0 0 4px;}

.replbq {margin:4;}

-->



____________ _________ _________ _________ _________ _________ _Ready for the edge of your seat?

Check out tonight's top picks on Yahoo! TV.

http://tv.yahoo. com/



[Non-text portions of this message have been removed]














<!--

#ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;}
#ygrp-vitnav{
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
#ygrp-vitnav a{
padding:0 1px;}
#ygrp-actbar{
clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar .left{
float:left;white-space:nowrap;}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;font-size:77%;padding:15px 0;}
#ygrp-ft{
font-family:verdana;font-size:77%;border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;}

#ygrp-vital{
background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
#ygrp-vital #vithd{
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
#ygrp-vital ul{
padding:0;margin:2px 0;}
#ygrp-vital ul li{
list-style-type:none;clear:both;border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
#ygrp-vital ul li .cat{
font-weight:bold;}
#ygrp-vital a {
text-decoration:none;}

#ygrp-vital a:hover{
text-decoration:underline;}

#ygrp-sponsor #hd{
color:#999;font-size:77%;}
#ygrp-sponsor #ov{
padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov li{
list-style-type:square;padding:6px 0;font-size:77%;}
#ygrp-sponsor #ov li a{
text-decoration:none;font-size:130%;}
#ygrp-sponsor #nc {
background-color:#eee;margin-bottom:20px;padding:0 8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad #hd1{
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
#ygrp-sponsor .ad a{
text-decoration:none;}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;}
#ygrp-sponsor .ad p{
margin:0;}
o {font-size:0;}
.MsoNormal {
margin:0 0 0 0;}
#ygrp-text tt{
font-size:120%;}
blockquote{margin:0 0 0 4px;}
.replbq {margin:4;}
-->










____________________________________________________________________________________
Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online.
http://smallbusiness.yahoo.com/webhosting

[Non-text portions of this message have been removed]