Re: Partner index does not exist or is inactive.

Tue, 25 Mar 2008 00:58:57 -0700 

On Tue, 25 Mar 2008 08:09:41 +0300, Taras Kucher <[EMAIL PROTECTED]> wrote:

> как активировать все индексы?

set term ^ ;
execute block as
   declare variable SQLCommand varchar(100);
   declare variable trigger_name varchar(32);
   declare variable trigger_inactive integer;
begin
   for select rtrim(t.rdb$trigger_name), t.rdb$trigger_inactive
     from rdb$triggers t
     where not exists (select 1 from rdb$check_constraints chk where 
t.rdb$trigger_name = chk.rdb$trigger_name) and
           ((t.rdb$system_flag != 1) or (t.rdb$system_flag is null))
     order by t.rdb$trigger_name
     into trigger_name, trigger_inactive
   do
     if (trigger_inactive = 1) then begin
       SQLCommand = 'ALTER TRIGGER ' || trigger_name || ' ACTIVE;';
       execute statement SQLCommand;
     end
end^
set term ; ^


-- 
Сергей Смирнов.

Ответить