Fabricio,

IB does _not_ only allow 1000 calls. It limits the depth of the return stack to
1000 layers, which is a very different thing. Recursive procedure are extremely
useful, and I would guess that in 99.9% of cases where recursive procedures are
used the depth does not exceed 20.

Regards

Vince

Fabricio Araujo wrote:

>
> Don't use recursive procedures.
> IB allows only a 1000 calls, someone knows if this limit was
> modified by Firebird guys (Mark?) ?
>
> --Original Message Text---
> From: Agung Wibudi
> Date: Thu, 22 Mar 2001 19:26:09 +0700
>
> Hi All,
> I 've problems with sorting data that implement with stored procedure.
> The Store procedure is Recursive's stored procedure.
> Structure data in table like :
> field1 ID CHAR(2),
> field2 Parent_id char(2) (Child of field1),
> field3 Level integer (The level Of record , 1 is parent, 2 is child, etc)
>
> I want to sort that table like parent child method or (Tree View).
>
> I always failed to get the results (returns in SP always NULL use Suspend).
>
> How to get the output of the child record ;
>
> thank's
>
> Yahoo! Groups Sponsor
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
> []s Fabricio
> Systems Developer
>
>
> 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/

--
Vince Duggan
Synectics Software
Inprise C/S Business Partner
South Africa
http://www.synectics.co.za
mailto:vince@...