Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
XmlToCursor()
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
XmlToCursor()
Divers
Thread ID:
00552820
Message ID:
00552820
Vues:
59
I need help here!

I play a little bit the function XmlToCursor(). It's simple to use and make a good job.

Now, i see this function can manage some objects like ADO Steam or XMLDOM.

So i try that:

oConnection = NEWOBJECT("ADODB.Connection")
oStream = NEWOBJECT("ADODB.Stream")

oConnection.Provider = "SQLOLEDB.1"
oConnection.ConnectionString = ;
"Persist Security Info=False;User ID=sa;"+;
"Initial Catalog=Shipping;Data Source=FS01"
oConnection.open

oRecordSet = NEWOBJECT("ADODB.RecordSet")
lSelect = "SELECT * FROM SENDER"
oRecordSet.Open(lSelect, oConnection)

oRecordSet.Save(oStream, 1)
RELEASE oRecordSet
RELEASE oConnection

XMLTOCURSOR('oStream', "MyCursorName", 1028)
RELEASE oStream

SELECT MyCursorName
BROWSE

All is ok for me, but the XMLTOCURSOR dont want to take my oStream!?!

I try with a XML file and he take it, but now it's an object. He give me "XML parse error: invalid at the top level of the document. Line 1, Position 1. oStream".

The last parameter is a flag additive. I try a lots of combinaisons.

Maybe i miss something,

Thank u for your help.

Francois
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform