Recursiv/hierarchical query?

[Bart Pietercil]

Hi Guys,

why wouldn't you do this through a stored procedure ? little while  
loop....

Bart
On 30 Dec 2008, at 15:38, Ruslan Zasukhin wrote:

> On 12/30/08 4:15 PM, "Paul Gaspar" <devlist at revolversoft.com> wrote:
>
> Hi Paul,
>
> Yes such feature exists in Oracle and others.
> Usually very different.
>
> SQL99? I have see in SQL99 that recursive queries can be solved with  
> help of
> CREATE TYPE, and so on. But query is on one page size.
>
> I did have ideas of such queries for Valentina using Vlink. Not  
> remember now
> in API or on SQL I was going did it. Probably in both,
>
> How urgent this is for you?
>
> Please fill feature request into Mantis first of all, and point TIME  
> you
> need it.
>
> And ... Lets continue discussion how this can be solved in best way  
> for
> Valentina.
>
> Welcome URLs and examples of SQLs from Oracle and MSN.
> Okay?
>
>
>
>
>> Yes, I think its possible in MS SQL and Orcale, and part of SQL99.
>> (START WITH ... CONNECT BY)
>>
>> Paul
>>
>>
>>
>> Am 30.12.2008 um 14:34 schrieb william humphrey:
>>
>>> Without writing the joins? Is this something available in other SQL?
>>>
>>> On Tue, Dec 30, 2008 at 9:22 AM, 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?
>
> -- 
> 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