XML to ADO Recordset

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

Article #3715

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

#3715

From: mmorris
Date: Wed, 26 Jun 2002 16:46

19 lines
1445 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: <9e06198c.0206260846.1d2db101@posting.google.com>

Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,f38faff5d0a5e817,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-06-26 09:46:57 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail
From: mmorris@go-asi.com (mmorris)
Newsgroups: borland.public.cppbuilder.database.ado
Subject: XML to ADO Recordset
Date: 26 Jun 2002 09:46:56 -0700
Organization: http://groups.google.com/
Lines: 19
Message-ID: <9e06198c.0206260846.1d2db101@posting.google.com>
NNTP-Posting-Host: 66.180.109.91
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1025110017 12424 127.0.0.1 (26 Jun 2002 16:46:57 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 26 Jun 2002 16:46:57 GMT