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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement