Re: Hierarchical Recordset
From: Ivan Debono (ivanmdeb_at_hotmail.com)
Date: 07/20/04
- Next message: Randy Danielson: "getting child DataTable from relation"
- Previous message: Ivan Debono: "Re: Hierarchical Recordset"
- In reply to: Val Mazur: "Re: Hierarchical Recordset"
- Next in thread: Val Mazur: "Re: Hierarchical Recordset"
- Reply: Val Mazur: "Re: Hierarchical Recordset"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 20 Jul 2004 12:17:48 +0200
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: Randy Danielson: "getting child DataTable from relation"
- Previous message: Ivan Debono: "Re: Hierarchical Recordset"
- In reply to: Val Mazur: "Re: Hierarchical Recordset"
- Next in thread: Val Mazur: "Re: Hierarchical Recordset"
- Reply: Val Mazur: "Re: Hierarchical Recordset"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
