MariaDB ROWSET Error when using WITH RECURSIVE clause

Board index FiveWin for Harbour/xHarbour MariaDB ROWSET Error when using WITH RECURSIVE clause

Posts: 336

Joined: Mon Dec 07, 2009 02:49 PM

MariaDB ROWSET Error when using WITH RECURSIVE clause

Posted: Fri Oct 11, 2019 04:53 AM

Dear Rao Sir ,

I am getting an Error when use below SQL statement in the RowSet. Could you please guide on this.

ERROR : "Method Rowset : Invalid SQL :"

Code (fw): Select all Collapse

   
WITH RECURSIVE tgl2 as ( 
    SELECT agrp_id, parent_id
FROM va01
WHERE PARENT_ID = 9
UNION ALL
SELECT g.agrp_id, g.parent_id
FROM va01 g, tgl2 p
WHERE g.PARENT_ID = p.agrp_id
) 
SELECT AGRP_ID, tgl2.parent_id FROM tgl2 
ORDER BY 2,1 ;

Thanks
Shridhar

Thanks

Shridhar

FWH 24.04, BCC 7 32 bit, MariaDB

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: MariaDB ROWSET Error when using WITH RECURSIVE clause

Posted: Fri Oct 11, 2019 05:44 AM

We understand.
Can you try with

aData := oCn:Execute( cSql )

and see if you are able to get the result into the array?

Regards

G. N. Rao.

Hyderabad, India

shri_fwh

Posts: 336

Joined: Mon Dec 07, 2009 02:49 PM

Re: MariaDB ROWSET Error when using WITH RECURSIVE clause

Posted: Sun Oct 13, 2019 04:59 AM

Dear Rao Sir ,

Thanks a lot for this solution now its working...!

Thanks
Shridhar

Thanks

Shridhar

FWH 24.04, BCC 7 32 bit, MariaDB

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: MariaDB ROWSET Error when using WITH RECURSIVE clause

Posted: Sat Nov 23, 2019 09:43 AM

FWH 1910: RowSet accepts this type of SQL statement

Regards

G. N. Rao.

Hyderabad, India

shri_fwh

Posts: 336

Joined: Mon Dec 07, 2009 02:49 PM

Re: MariaDB ROWSET Error when using WITH RECURSIVE clause

Posted: Mon Nov 25, 2019 04:24 AM

Dear Rao Sir ,

Thanks a lot ...!

Thanks
Shridhar

Thanks

Shridhar

FWH 24.04, BCC 7 32 bit, MariaDB

FiveTech Support Forums

MariaDB ROWSET Error when using WITH RECURSIVE clause

Re: MariaDB ROWSET Error when using WITH RECURSIVE clause

Re: MariaDB ROWSET Error when using WITH RECURSIVE clause

Re: MariaDB ROWSET Error when using WITH RECURSIVE clause

Re: MariaDB ROWSET Error when using WITH RECURSIVE clause

Continue the discussion