[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] Recursion in SQR
- Subject: Re: [sqr-users] Recursion in SQR
- From: Yuri Lakef <lakef250@yahoo.com>
- Date: Thu, 8 Apr 2004 08:13:44 -0700 (PDT)
- Delivery-date: Thu, 08 Apr 2004 10:14:45 -0500
- In-reply-to: <200404072214.i37MEJSx030983@web121.megawebservers.com>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Thanks for the response. I was able to get the desired effect by using an
array and then processing from bottom of array to top by decrementing
#array_count.
Thank you again.
jwillson@dssltd.com wrote:
Hi, you can get tail recursion by using a stack adt that I wrote and
provided to the sqrug. (see http://www.dssltd.com |clients only|sqrug sqrug)
The stack limit is preset at 100 but recompiling will allow you to go as
deep as your cpu's memory.
John Willson
Yuri Lakef said:
> Greetings,
>
> Will SQR allow calling the same function (procedure) recursively?
>
> I'd like to process a tree and print data to flat file. I only want to
call procedures to print record once I'm at the bottom-most level (i.e., no
rows found where Parent_Node_Num is equal to a particular Tree_Node). The
particular tree I'm processing has up to 10 levels (call same procedure for
each level for different TREE_NODE).
>
> Thanks in advance!
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Small Business $15K Web Design Giveaway - Enter today
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
>
--
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
---------------------------------
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway - Enter today
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users