>Zlatin,
>
>I'm going to realize CursorToXml and XmlToCursor functions in OLEDB library, which you can find in download section. These functions are already included into library, but they are not jet working and therefore not documented. Currently they are not derived from IVFPXML interface. The main problem for me is achieving the same speed for CursorToXml as for native VFP7 function. XmlToCursor is based on SAX2 API and seems to be more efficient than native function, but requires a further optimization. I hope to finish this work within one-two months.
>I could also suggest to use ADO recordset XML persistence:
>
>oOleDb = CreateObject("OleDbFox.Utils")
>oRecordSet = CreateObject("ADODB.Recordset")
>oOleDb.CursorToRs(oRecordSet)
>oRecordset.Save("MyCursor.xml", 1)
>oRecordSet.Close()
>
>...
>oRecordset.Open("MyCursor.xml")
>oOleDb.RsToCursor(oRecordSet, 'mycursor')
>oRecordSet.Close()
>
>
>Alexander
In our case, using ADO is not a good option, because ADO has its own implementation of XML export/import which is not compatible with the format from VFP xml support functions.
Achieving the same speed is really a problem, because when implementing IVFPXML you need to pass COM boundaries each time you read cursor data or set variable.
Regards
Zlatin Zlatev,
MCSD (VS6)Make solutions, not programs!