The query below works great in SQL Studio now that I fired up my Windows
client. Unfortunately for me I was using WebSQL and it doesn't return any
records there. Why would that be? Where does one report a bug?
Is there a Linux command line interface to SAPDB (That doesn't have this
bug)? I'm just starting with SAPDB.
Thank you for your help.
Dan
> ----- Original Message -----
> From: =?iso-8859-1?Q?Wolfram=20N=FCcker?=
> To: "DanFitzpatrick"
> Sent: Wed, 27 Feb 2002 12:24:38 +0100
> Subject: Re: Recursive Query - No Result
>
> once again, this time copy&pasteable for SQL Studio
> regards
> Wolf
>
>
>
> CREATE TABLE parentchild
> (
> parent varchar(10),
> child varchar(10)
> )
> //
> INSERT INTO parentchild( parent, child ) values ('Bart', 'Lisa')
> //
> INSERT INTO parentchild( parent, child ) values ('Homer', 'Marge')
> //
> INSERT INTO parentchild( parent, child ) values ('Marge', 'Bart')
> //
> INSERT INTO parentchild( parent, child ) values ('Abe', 'Homer')
> //
> INSERT INTO parentchild( parent, child ) values ('Ape', 'Abe')
> //
> DECLARE C CURSOR FOR
> WITH RECURSIVE family(p,c) AS
> ( SELECT parent, child
> FROM parentchild
> WHERE parent = 'Homer'
> UNION ALL
> SELECT parent, child
> FROM parentchild, family
> WHERE family.c = parentchild.parent
> ) SELECT * FROM FAMILY
>
> ________________________________________________________________
> Keine verlorenen Lotto-Quittungen, keine vergessenen Gewinne mehr!
> Beim WEB.DE Lottoservice: http://tippen2.web.de/?x=13
>
>
>
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
