Re: Maybe it's a bug

Tech-Archive recommends: Fix windows errors by optimizing your registry




"Lorry Astra" <LorryAstra@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B9669AA0-CBAE-4F75-A69F-AF937C4868A1@xxxxxxxxxxxxxxxx
hi,
i encountered a difficulty when i tried to open a DomDocument object.
And
i could get different RecordCount when i open the xml.
pls follow my way to recap the scene.
1. rs.Save Domtmp, adPersistXML (rs is an object of the ADO.Recordset, and
to be sure the rs.recordcount is more than 2 now)
2. To revise Domtmp.
for example:
To revise this xml style
<rs:data>
<z:row ....../>
<z:row ....../>
<z:row ....../>
</rs:data>
to the style below.
<rs:data>
<z:row ......></z:row>
<z:row ......></z:row>
<z:row ......></z:row>
</rs:data>

3.Both the two style are correct.

It appears that either form parses identically. The only inference I can
draw is that ADO doesn't use MSXML to parse xml-persisted recordsets?

I'm not sure I'd call it a bug though -- why do you want/need to alter the
structure?


-Mark



But when we load then style which is
changed.
DomTmp.loadxml(.....);
And i use a ADO RecordSet object to open it.
rs.open DomTmp
And now u check the recordcount, it's 1 instead of 3. But i think 3 is
correct. In my opinion, there is something wrong when ADO.RecordSet
analyzes
the xml style.
Could u tell me how to resolve it. Thanks

My Dev Environment:
Win2000 sp4
ADO 2.6



Sincerely,

Lorry



.



Relevant Pages

  • ADO Function Needed
    ... I seem to repeat the same ADO call because the ... .RecordCount is dynamic, even though the actual SQL is the same. ... to create a function that executes the query, opens the recordset, then ...
    (microsoft.public.data.ado)
  • Re: AbsolutePosition Problem
    ... > It sounds like you are still using ADO Recordsets, ... > DataTables and DataSets, right? ... > AbsolutePosition and RecordCount were never recommended for reliable ... > you are recieving -1 for AbsolutePosition, ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Problems querying DB2 through ADO
    ... you cannot count on an accurate recordcount from any driver. ... > ADO you can use adUseClient cursor and it will cursor the records on the ... > client side an provide recordcount for you, but the price for this is caching ... Unfortunately my code relies entirely on it. ...
    (microsoft.public.data.ado)
  • Re: VB6 & SQL2000 Stored Proc problem
    ... Consider that COM-based ADO returns control to the application BEFORE rowset population is complete for some cursors. ... See "ADO and ADO.NET Examples and Best Practices " or "Hitchhiker's Guide to Visual Basic and SQL Server " for details--and suggestions about why it's not a good idea to use SELECT *. ... Are you assuming theres' too many records based on the return from .RecordCount? ...
    (microsoft.public.vb.database.ado)
  • Re: AbsolutePosition Problem
    ... > opening to get an accurate recordcount. ... >> It sounds like you are still using ADO Recordsets, ... >> you are recieving -1 for AbsolutePosition, ... >> You should consider using ADO .NET and loading your data into DataTables ...
    (microsoft.public.dotnet.languages.vb)