Evan,

That would be very convenient, although we can do it already with just an extra line of code. VFP7, of course, has the cursor/XML converters built in (and swappable with third-party ones with a system var setting).

I think you'd need to also add a keyword to indicate what type of XML format you want (look at the parameters on the VFP7 cursor/XML routines).

However, I don't know that I'd think of these as high enough priorities for VFP development resources to be spent on them. Perhaps a better idea is just a little utility function that you could call with a select statement as one of the params, which could use the built-in converters and output what you wanted.

Please post here when you've got it written. :-)


>What does everyone think of modify VFP SQL statement to directly work with XML? This would be instead of converting to and from CURSORS with Rick's class. This would mirror SQL Server 2000 in some ways.
>
>* can select directly from an XML string into a cursor
>SELECT * FROM XML cXMLString WHERE name = "A" INTO CURSOR curPatients
>
>* select from a cursor into an XML string
>SELECT * FROM curPtients WHERE name = "A" INTO XML cXMLPatients
>
>* heck why not from XML to XML
>SELECT name, address FROM XML cXMLPatients WHERE name = "A" INTO XML cXMLSomePatients