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.

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

Why modify it?

Helen

>--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/

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________