Thanks for your reply.

I think my database is in problem, because when I tried to restored it, I got error

Engine Message :
validation error for column ID_DIV_LC, value "*** null ***"
warning -- record could not be restored

I think, may be there is a leak in Firebird to trap an error when null value allowed to store in a not null value definition. I forgot how to insert this null value to the database.

Thanks and regards,
Sugiarto

> What's the execution plan? If it's using an index on ID_DIV_LC and the
> following returns a result set:
>
> select
> *
> from
> m_int_frm a
> where
> a.id_trs_typ = 100
> and a.id_div_lc + 0 = 0
>
>
> Then your index on ID_DIV_LC might be problematic/corrupted.
>
>
> --
> With regards,
> Thomas Steinmaurer (^TS^)
> Firebird Technology Evangelist
>
> http://www.upscene.com/
>
> Do you care about the future of Firebird? Join the Firebird Foundation:
> http://www.firebirdsql.org/en/firebird-foundation/
>