Re: XML to ADO Recordset and Back again

Yes, let's see the saved xml so we can repro it ourselves.

Barry Seymour wrote:
Sorry, didn't help. I still get only one row.

More details:
1. I fetch an ADO recordset
2. I save it to global XML document. It has the MS Schema info, which
I need to allow for so I can do xpath queries. Hence the two calls to
.SetProperty to set SelectionLanguage and SelectionNameSpaces.
3. When I want to sort I convert it back to ADO - that's when I get
the single record.


"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> wrote in message
news:e5tlhIYqIHA.1952@xxxxxxxxxxxxxxxxxxxxxxx
Well, it may help, but I just looked at your code and you are setting
xml properties that should already be set in your xml file. Try
removing those lines and simply open your recordset on the xml
document, which I assume was the result of using the recordset.save
method ...

Barry Seymour wrote:
Yes. I have XML spy and I can confirm the XML has all records.
Can/should I post the XML here?

"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> wrote in message
news:%23xTLNgXqIHA.4928@xxxxxxxxxxxxxxxxxxxxxxx
Can you look at the xml and confirm it contains all the records?

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: Classic ASP to .NET WebService interfacing (Dataset to RecordSet)
    ... Or, you can send the XML of the ADO recordset back, and re-construct it on ... Use Interop on the server to work with the ADO recordset. ...
    (microsoft.public.inetserver.asp.general)
  • Re: How to Programmatically Export as XML & SXL
    ... Unfortunately, I've had precious little to do with XML in Access, so I'm ... you use the ADO Recordset object's Save ... >>Dim rs As ADODB.Recordset ... >>Dim strADTGFile As String ...
    (microsoft.public.access.externaldata)
  • Re: MDAC Converting Dataset to XML
    ... I hadn't realised there was a later version of MDAC than the one we had ... recordset is fine, the code that does this is a mirror of the conversion to ... XML and for completeness I include a copy (albeit ... Can you reproduce the symptom by saving the first piece of xml to a file, ...
    (microsoft.public.data.ado)
  • Re: Database + dll
    ... You can include an XML or ADTG persisted Recordset with the ... XML can be compiled into a DLL as a resource, ... copied to a stream first anyway (not that the recordset would alter the ... It's a simple matter of creating a custom resource type from an XML file at ...
    (microsoft.public.vb.database.ado)
  • Re: XSD to Pascal Objects?
    ... > we're talking about a very niche, specific market. ... > be too simple to justify a high price or else no one would buy it. ... > another, nested recordset. ... > an XML file, it saves all the child recordsets too. ...
    (borland.public.delphi.thirdpartytools.general)