Spasibo Dima, I used TFDQuery with
EXECUTE BLOCK AS
DECLARE VARIABLE stmt VARCHAR(1000);
BEGIN
for select 'ALTER INDEX '||rdb$index_name ||' ACTIVE;'
from rdb$indices
where (rdb$system_flag is null or rdb$system_flag = 0)
order by rdb$foreign_key nulls first
into :stmt
do EXECUTE STATEMENT
08.01.2018 23:09, fredf...@hotmail.com [firebird-support] wrote:
> No exception raised but indexes ar e not ac tivated! What is wrong? How can I
> activate all
> indexes correctly?
1. Indexes are activated on commit.
2. You don't need to use script component in Delphi, "execute block" is a
I used script in FlameRobbin to activate all indexes successfully:
SET TERM !! ;
EXECUTE BLOCK AS
DECLARE VARIABLE stmt VARCHAR(1000);
BEGIN
for select 'ALTER INDEX '||rdb$index_name ||' ACTIVE;'
from rdb$indices
where (rdb$system_flag is null or rdb$system_flag = 0)
order by rdb$foreign_key