> > I need detect and stop infinite recursive calling of triggers or

SPs ?

>
> Firebird does it for you. It will throw an error as soon as you reach
> about 1000 nested calls.
>

Thanks for reply ...
Suppose situation when I insert row in table "T", which has insert
trigger in which is conditional insert into "T" ...

1. insert into T ...
2. trigger is fired ... and inside trigger is again insert into T ...
(so step 2 may be executed multiple times)

If infinite loop occurs and FB stops with error at approx. 1000 nesting
levels ... all changes into table T (including step 1. - original SQL
insert statement) will be rolled back ?

TIA
-Laco.