Recursiv/hierarchical query?

[Bart Pietercil]

Hi Ruslan,

continuing the discussion here


so are you saying that for the moment there is NO SAVE way to traverse  
a hierarchy in Valentina SQL ?


Bart


On 04 Jan 2009, at 00:01, Ruslan Zasukhin wrote:

> On 12/30/08 3:22 PM, "Paul Gaspar" <devlist at revolversoft.com> wrote:
>
>> Hi all,
>>
>> is there a way to create recursive/hierarchical selects within
>> Valentina SQL?
>>
>> Something which finds all childs, grandchilds and so on within a
>> table, performs the query on every item and unions the result?
>
> Hi Paul,
>
> I see you have not yet made feature request on this.
> Feature is not important for you?
>
> In any case, we have think here, and probably in about 4-6 days we  
> will
> implement the following new methods:
>
> Vlink.FindDescendents( inLevel as Integer = UINT_MAX) as  VSet
>
> Vlink.FindAncestor( inLevel as Integer = UINT_MAX) as  VSet
>
> Vlink.FindSiblings() as VSet
>
>
> Vlink must be self-recursive for these methods.
>
> Sense of methods I think is very clear.
>
> InLevel specify optionally level to move down or up by recursion.
>    i.e. Specify next/prev "generation".
>
>
>
> After we will make this on API level, we will plug this somehow into
> Valentina SQL.
>
>
>
> -- 
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina