Re: Hierarchical Recordset

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

  • Next message: Reem: "establish a connection" 
    Date: Tue, 20 Jul 2004 21:45:58 -0400

    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: Reem: "establish a connection"

    Relevant Pages