Re: Hierarchical Recordset

From: Val Mazur (group51a_at_hotmail.com)
Date: 07/20/04 

Date: Mon, 19 Jul 2004 22:11:40 -0400

Hi Ivan,

Yes, this is the way to go and there is no simple solution in this case.
Shaped recordset good feature, but pretty complex, when you need to do
something like this. Actually MDAC 2.8 applied some limitation son a depth
of the shaped recordsets and it could be an issue as well. Best way is to
migrate to the .NET, where you could set DataSet with the related
DataTables. 

-- 
Val Mazur
Microsoft MVP
"Ivan Debono" <ivanmdeb@hotmail.com> wrote in message 
news:eyqOfsYbEHA.3716@TK2MSFTNGP11.phx.gbl...
> Hi all,
>
> I need to export a hierarchical recordset to xml to be later imported and
> inserted as a new recordset in a different database.
>
> Sounds easy.... hmmm... so here are my problems!!
>
> 1. I need to export the recordset as a 'package', that is data in related
> tables need to be exported too. This is necessary to maintain integrity 
> when
> importing back. Anyways, the hierarchy can go 8 to 10 levels deep and can
> include 10 to 20 different tables. Yes it's complex stuff!!
>
> I was looking at the Shape command but I think this is out of the question
> trying to build a shape command so complex.
>
> Although the following is not suggested and not supported by MS, I have a
> feeling this is the only way to solve my problem:
> a) Manufacture a recordset based on the original recordset (which also
> contains records).
> b) Copy records from the original to the manufactured.
> c) Add any necessary adChapter fields and set them to child recordsets
> d) Persist to xml/adtg
>
> Is this the way to go??
>
> Thanks,
> Ivan
>
>

Relevant Pages

  • Re: DataSource class help
    ... > control to the Shaped Recordset but the problem arises when you want to ... > a part of this recordset and apply it to another 'normal' recordset. ... >> It might just be the control. ... Don't open an ADO Connection in the Class_Initialize event. ...
    (microsoft.public.vb.general.discussion)
  • Re: DataSource class help
    ... control to the Shaped Recordset but the problem arises when you want to take ... a part of this recordset and apply it to another 'normal' recordset. ... >> Private Sub Class_GetDataMember ... > It might just be the control. ...
    (microsoft.public.vb.general.discussion)
  • Re: Hierarchical Recordset
    ... > inserted as a new recordset in a different database. ... > trying to build a shape command so complex. ... > a) Manufacture a recordset based on the original recordset (which also ... > c) Add any necessary adChapter fields and set them to child recordsets ...
    (microsoft.public.data.ado)
  • Re: Hierarchical Recordset
    ... > inserted as a new recordset in a different database. ... > trying to build a shape command so complex. ... > a) Manufacture a recordset based on the original recordset (which also ... > c) Add any necessary adChapter fields and set them to child recordsets ...
    (microsoft.public.vb.database.ado)
  • Re: Hierarchical Recordset
    ... > inserted as a new recordset in a different database. ... > trying to build a shape command so complex. ... > a) Manufacture a recordset based on the original recordset (which also ... > c) Add any necessary adChapter fields and set them to child recordsets ...
    (microsoft.public.vb.general.discussion)