MariaDB ROWSET Error when using WITH RECURSIVE clause

[shri_fwh]

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: Select all

   
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

[nageswaragunupudi]

We understand.
Can you try with

aData := oCn:Execute( cSql )

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

[shri_fwh]

Dear Rao Sir ,

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

Thanks
Shridhar

[nageswaragunupudi]

FWH 1910: RowSet accepts this type of SQL statement

[shri_fwh]

Dear Rao Sir ,

Thanks a lot ...!

Thanks
Shridhar