Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XMLToCursor limits
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00669425
Message ID:
00669596
Views:
21
>Thanks David, so? do we have a bug?, there is a huge perfomance penalty with XMLToCursor(). To solve my problem, I have to change the way I get and return my results, but I don't want to do it.

As alternative to XMLToCursor() you could use ADO persistence in XML format + OLEDB library (file #10002):
oOleDb = CreateObject("OleDbFox.Utils")
oRecordSet = CreateObject("ADODB.Recordset")

oOleDb.CursorToRs(oRecordSet, "cPred")
oRecordset.Save("tmp.xml", 1)
oRecordset.Close()

Close tables all
oRecordset.Open("tmp.xml")
oOleDb.RsToCursor(oRecordSet, "cNew")
oRecordset.Close()
Previous
Reply
Map
View

Click here to load this message in the networking platform