Kapatmak için
execute block as
declare variable xname varchar(100);
declare variable xsql varchar(100);
begin
for select rdb$trigger_name from rdb$triggers where rdb$trigger_source is not null and coalesce(rdb$system_flag, 0) = 0 and rdb$trigger_source not starting with 'CHECK'
into :xname
do
begin
xname = trim(xname);
xsql = 'alter trigger ' || :xname || ' inactive';
execute statement xsql;
end
end
Açmak için
execute block as
declare variable xname varchar(100);
declare variable xsql varchar(100);
begin
for select rdb$trigger_name from rdb$triggers where rdb$trigger_source is not null and coalesce(rdb$system_flag, 0) = 0 and rdb$trigger_source not starting with 'CHECK'
into :xname
do
begin
xname = trim(xname);
xsql = 'alter trigger ' || :xname || ' active';
execute statement xsql;
end
end