Re: Hierarchical Recordset
From: Ivan Debono (ivanmdeb_at_hotmail.com)
Date: 07/21/04
- Next message: Ivan Debono: "Re: Hierarchical Recordset - Would this alternative work??"
- Previous message: Reem: "establish a connection"
- In reply to: Val Mazur: "Re: Hierarchical Recordset"
- Next in thread: Ivan Debono: "Re: Hierarchical Recordset - Would this alternative work??"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 21 Jul 2004 10:52:56 +0200
Going through it. Hope it helps!!
"Val Mazur" <group51a@hotmail.com> schrieb im Newsbeitrag
news:u7uW4RsbEHA.3864@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> You could probably do this using DOM model of the Access, but it would be
> pretty *heavy*. If I am not wrong Access DOM model will work out of
process,
> which is slowing down the whole process.
> Check next KB to see if SHAPE could help you fabricate recordset
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;241202&Product=ado
>
> --
> Val Mazur
> Microsoft MVP
>
>
> "Ivan Debono" <ivanmdeb@hotmail.com> wrote in message
> news:OCSMmIkbEHA.1152@TK2MSFTNGP09.phx.gbl...
> > Well, I was looking further to find an 'easy' solution for my problem. I
> > noticed that Access 2002 upwards has ImportXML and ExportXMl functions
in
> > the Application object. The MSDN document states:
> >
> > "Programmatically, Access 2002 added two new methods to work with XML:
> > ImportXML and ExportXML. The ImportXML method is used to import XML data
> > and
> > schema information into Microsoft SQL ServerT 2000 Desktop Engine,
> > Microsoft
> > SQL Server 7.0 or later, or the Microsoft Jet Database Engine. The
> > ExportXML
> > method allows you to export XML data, schemas, and presentation
> > information
> > from SQL Server 2000 Desktop Engine, SQL Server 6.5 or later, or the
> > Microsoft Jet Database Engine."
> >
> > Is it possible to call 'somehow' these 2 functions from within a VB app
> > using ADO? Access could not be available on the target machine though.
> >
> > Ivan
> >
> > "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 - Would this alternative work??"
- Previous message: Reem: "establish a connection"
- In reply to: Val Mazur: "Re: Hierarchical Recordset"
- Next in thread: Ivan Debono: "Re: Hierarchical Recordset - Would this alternative work??"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
