Subject Re: [ib-support] Recursive procedure
Author Fabricio Araujo
On Wed, 28 Mar 2001 17:06:13 +1000, Helen Borrie wrote:

>At 12:00 AM 28-03-01 -0300, you wrote:
>>Don't use recursive procedures.
>>IB allows only a 1000 calls,
>Correction, it limits the depth of recursion to somewhere around 1000 (Ann H will tell us the exact depth, if it is interesting enough !) The limit is there because any
procedure that recurses *that* many layers deep just HAS to be recursing infinitely.

A thousand calls can be fastly reached on a great number of records...
A thesaurus-like SQL-based keyword search interface can at this depth
much fast... I had to completely rewrite a select procedure because of
this, months ago.

>>someone knows if this limit was
>>modified by Firebird guys (Mark?) ?
>Why modify it?

Only to get a status....

[]s Fabricio
Systems Developer