Answer by Jason Chapman:
==>
Can't, IB detects the 1000 depth and barfs (as I guess you have found out),
thinking you have gone into an infinite loop.
Q's:
1) How Deep are you likely to need it to go?
2) Does each iteration require new data from tables?
3) What is the nesting for?


Choices are:
1) Tweak FB and rebuild - I would imagine that it is a constant somewhere.
2) Change your algorithm
3) Do it outside FB

Jason Chapman

JAC2 Consultancy
<==

On Mon, 16 Sep 2002 18:35:35 -0300, Valdir Stiebe Junior wrote:

>Hi! We have a SP here that have to be recursive due to an auto relationship.
>This SP sometimes raise an error: Too Many Concurrent Execution of the Same
>Request'.
>I'm sure that this SP will not get in an endless loop.
>So, how can i solve this?
>How firebird detect this 'recursive sp' and how to change this limitation?
>
> TIA.
>
>Valdir.
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>


[]s Fabricio
Systems Developer