> > Hi Experts,
> >
> > I would like to open the xml in visual forpro. I tried running the explorer and find the xml file and right click open with "visual foxpro 9.0 sp2". I just got empty vfp screen.I just wanted to count number of lines of an xml file.
> >
> Hi Madhan
>
> You can actually open the file itself via FileToStr() (or FOpen(), FRead() and so on).
> Or use XmlToCursor() / CursorToXML() for relatively simple XML. Or use the XMLAdapter class, e.g. for XML containing more than one table.
> Or use the MS "DOM", e.g.
>

> loXML = CREATEOBJECT("Msxml2.ServerXMLHTTP")
> 

>
> BTW, the number of lines in an XML file is actually irrelevant, the content can even be all in one line and would still be valid.
>
>
> hth
> -Stefan

Hi Stefan,

Thanks again. I will look into it.