Re: Hierarchical Recordset
From: Ivan Debono (ivanmdeb_at_hotmail.com)
Date: 07/20/04
- Next message: Ivan Debono: "Re: Hierarchical Recordset"
- Previous message: Julio: "Re: Fields that match condition"
- In reply to: Val Mazur: "Re: Hierarchical Recordset"
- Next in thread: Ivan Debono: "Re: Hierarchical Recordset"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 20 Jul 2004 10:51:59 +0200
Migrating is not an option at the moment :(
"Val Mazur" <group51a@hotmail.com> schrieb im Newsbeitrag
news:enIdl7fbEHA.212@TK2MSFTNGP12.phx.gbl...
> 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
> >
> >
>
>
- Next message: Ivan Debono: "Re: Hierarchical Recordset"
- Previous message: Julio: "Re: Fields that match condition"
- In reply to: Val Mazur: "Re: Hierarchical Recordset"
- Next in thread: Ivan Debono: "Re: Hierarchical Recordset"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
