Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursortoxml & xmltreeview control (MS)
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Cursortoxml & xmltreeview control (MS)
Miscellaneous
Thread ID:
00719360
Message ID:
00719360
Views:
59
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
Next
Reply
Map
View

Click here to load this message in the networking platform