What is the best technique to exchange data from VFP/COM-DLL to client (VFP or VB.NET)? Now I use XML in VFP, because I can easily convert XML to cursor (or reverse) with XmlToCursor() or CursorToXML(). But it's slowly with among of data (because XmlDOM). I wonder if I could use another way to exchange data between layer? What is your suggestion? By example, can I use a recordset between both entities? Is using SAX instead XmlDOM could be better and, if so, how to implements this to obtain the same result (a cursor)?
>> VFP client looks like...
obj = CREATEOBJECT("DataAccessLayer.cAccessTablesDBF")
obj.cTableName = "customers.dbf"
cXml = obj.GetXmlTable()
XMLTOCURSOR("cXml", "MyCursor", 1024)
release obj
>> COM-DLL server looks like...
use (cTableName) in 0 shared
CURSORTOXML(cTableName, "cXML", 1, 6, 0, "1")
use in (cTableName)
return cXML