>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()