Recursiv/hierarchical query?

[Ruslan Zasukhin]

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]