Can anyone explain the steps necessary to execute a spt from foxpro useing the for xml and then populate an xmltreeview control. I just playing around with the idea of displaying the information to the user and then thinking the treeview can drill down.

Here is the basic query I am trying:

SELECT  dbo.patients.lastname, dbo.patients.firstname, dbo.meetings.begintime, 
        dbo.meetings.endtime, dbo.meetproc.dcode, 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
FOR XML AUTO

Thanks in advance.
Kirk