Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Bug: CursorToXML(..., ..., ..., 48) ignores default loca
Message
De
08/08/2002 13:40:16
 
Information générale
Forum:
Visual FoxPro
Catégorie:
XML, XSD
Divers
Thread ID:
00686954
Message ID:
00687635
Vues:
47
>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")    && you can use VFPCOM instead of OleDbFox
>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!

Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform