XML to ADO Recordset

Article View: borland.public.cppbuilder.database.ado

Article #3733

Back to borland.public.cppbuilder.database.ado Previous Next

#3733

From: CM Morris
Date: Fri, 28 Jun 2002 13:42

19 lines
1533 bytes

I am currently calling a web service that returns an ADO recordset as
XML.  Using vbscript in an asp I can convert the xml back to a useable
ADO recordset.  I need to figure out how to do the same thing in using
Borland C++.  Is it possible to create an ADO recordset in Borland
from an XML stream?
Below is the vbscript code.  I am new to Borland so any help would be
greatly appreciated.  Thanks.

 Set xStream = Server.CreateObject("ADODB.Stream")
 Set rs = Server.CreateObject("ADODB.Recordset")

 rsAsXML = WebServiceCall()

 xStream.Open
 xStream.WriteText rsAsXML
 xStream.Position = 0

 rs.Open( xstream )
 xStream.Close

Technical Details

Message-ID: <3d1c674f$1_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!supernews.com!iad-peer.news.verio.net!news.verio.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,f38faff5d0a5e817
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-06-28 06:45:42 PST
Reply-To: "CM Morris" <mmorris@go-asi.com>
From: "CM Morris" <mmorris@go-asi.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: XML to ADO Recordset 
Date: Fri, 28 Jun 2002 07:42:14 -0600
Lines: 22
Organization: Advanced Solutions, Inc
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 66.180.109.91
Message-ID: <3d1c674f$1_1@dnews>
X-Trace: dnews 1025271631 66.180.109.91 (28 Jun 2002 06:40:31 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!supernews.com!iad-peer.news.verio.net!news.verio.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews