thanks
i am getting ready for my retirement at the end of this year. So one of my apps here at the state of Connecticut is being rewritten in c# and sqlserver by a vendor not familiar with VFP
so I did xmltocursor to hand over the date to them
is there a better way??
Peter
>>why is xmltocursor so much slower that cursortoxml???
>>
>>what can I do to speed it up ???
>>
>>the conversion to xml takes a few seconds, the revers days!!!!!
>
>
>
>What I have done is to create class which reads XML as text file ( filetostr() ) then breaks it down in segments
>from where I take stuff I need. Works very fast. I can read hundreds of XMLs (smaller custom XMLs) in a matter of seconds BUT I am NOT reading entire XML every single segment as to parse entire data set into some other table/cursor, but rather only part of info which is of significance to me.
>
>On reverse I use textmerge to produce custom XML back which is again very fast.
>
>No XMLDOM, no XML schemas, no XML parsers ;
>And no problem :-)
>
>I can sent u class code if u r interested. Did not round it up yet into something universally reusable but might be of
>use to you as jump start into producing your own custom XML readers / parsers .
>
>HTH
>Sergio
Peter Cortiel