>I have the following code and I thought it should create a physical XML file, but I it doesn't, at least not where I can find it. Also, does anyone know how to populate the MS xmltreeview control from an xml file?
>
>

>TEXT TO lccmd noshow
>SELECT TOP 100 PERCENT dbo.patients.lastname, dbo.patients.firstname,
>	dbo.meetings.begintime, dbo.meetings.endtime, dbo.meetproc.description,
>        dbo.meetproc.surgeon
>FROM    dbo.patients INNER JOIN
>        dbo.meetings ON dbo.patients.patientid = dbo.meetings.patientid INNER JOIN
>        dbo.meetproc ON dbo.meetings.meetingnumber = dbo.meetproc.meetingnumber
>ORDER BY dbo.patients.lastname, dbo.patients.firstname, dbo.meetings.begintime
>ENDTEXT
>
>SQLEXEC(gnConnHandle,lcCmd,"Cursql")
>SELECT cursql
>
>lnResults=CURSORTOXML('cursql','c:\query1.xml',1,2,0,"")
>
>

>
>Thanks

Kirk,
Add 512 to the flags value. This tells VFP to create a file. if you don't then it creates a memory variable called c:query1.xml.

Also, I have never used the XMLTreeView control so I can't help you with that.