Re: Hierarchical Recordset

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 07/19/04 

Date: Mon, 19 Jul 2004 09:53:22 -0700

I hate to see you reinventing the wheel. Many or all of these issues have
been resolved in ADO.NET. 

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"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: 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)
  • 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
    ... > Hi Ivan, ... > Shaped recordset good feature, but pretty complex, when you need to do ... >> trying to build a shape command so complex. ... >> c) Add any necessary adChapter fields and set them to child recordsets ...
    (microsoft.public.vb.general.discussion)
  • Re: Hierarchical Recordset
    ... > Hi Ivan, ... > Shaped recordset good feature, but pretty complex, when you need to do ... >> trying to build a shape command so complex. ... >> c) Add any necessary adChapter fields and set them to child recordsets ...
    (microsoft.public.data.ado)
  • Re: Hierarchical Recordset
    ... > Hi Ivan, ... > Shaped recordset good feature, but pretty complex, when you need to do ... >> trying to build a shape command so complex. ... >> c) Add any necessary adChapter fields and set them to child recordsets ...
    (microsoft.public.vb.database.ado)