Using memory resident ADO recordsets
Posted on 2006-07-16
I have been using memory resident ADO recordsets for a while in a Parent/Child relationship. Now for the question:
Is it possible to have one parent with a child and have the child have children? In other words, grandparent/parent/child relationship.
Here is code I am trying to play with:
Set rsItems = New ADODB.Recordset
Set rsItemsDtl = New ADODB.Recordset
Set rsItemsInvDtl = New ADODB.Recordset
rsItems.ActiveConnection = "provider=msdatashape;data provider=none;"
rsItems.Open " SHAPE APPEND" & _
" New adVarChar(40) as CustNbr, New adVarChar(100) as CustName, New adCurrency as YTD," & _
" New adCurrency as LYYTD, New adCurrency as LY," & _
" ((SHAPE APPEND New adVarChar(10) as chCustNbr," & _
" New adVarChar(40) as chProductNbr, New adVarChar(100) as chProductDesc, New adVarChar(30) as chSize," & _
" New adVarChar(10) as chMfg, New adVarChar(10) as chUnit, New adInteger as chQty," & _
" New adCurrency as chYTD, New adInteger as chLYtdQty, New adCurrency as chLYYTD," & _
" New adInteger as chLyQty, New adCurrency as chLY, New adVarChar(100) as chCustProd," & _
" ((SHAPE APPEND New adVarChar(40) as chIDCustProd, New adVarChar(10) as chIDInvNbr," & _
" New adDate as chIDInvDate, New adInteger as chIDQty, New adCurrency as chIDInvAmt)" & _
" RELATE chCustProd to chIDCustProd) AS Child)" & _
" RELATE CustNbr to chCustNbr) AS Child" _
, , adOpenDynamic, adLockOptimistic
I know that I am not doing this correctly.
When answering, please provide an example.