[RESOLVED] [VB6] hierarchical recordset

[jlbantang]

hi im creating a hierarchical recordset that will be pass as data report datasource but im receiving the error:


ACCESS VIOLATION or INVALID SYNTAX

Static rs As New ADODB.Recordset
rs.Open "SHAPE {select pono from tblpurchaseorder} " & _
        "APPEND (select description from tblPurchaseOrderItem) AS orderDetails RELATE tblpurchaseorder.recno TO tblpurchaseorderitem.recno", myConnection, adOpenKeyset, adLockReadOnly

Set rptAllSupplierPO.DataSource = rs

rptAllSupplierPO.show

btw im using SQL Authentication for the connection object.