Hi Dave,
The easist way to handle this problem is to already know the format of the data you're trying to get and to have an existing cursor already. Then you can use the new flag in XmlToCursor() (available with SP1) to append the records into your cursor, and VFP will then have the correct data types.
XmlToCursor(lcMyXML, "MyCursor", 8192)
~~Bonnie
>>If the WebService takes that DataSet and instead of returning it as is, returns oDS.GetXML() it will then return an XML string, which can easily be consumed by VFP. I recommend that WebServices return this rather than a DataSet.
>>
>
>Bonnie,
>
>How are you using the XML string returned from the Web Service?
>
>If I remember correctly, I had a difficult time converting the XML string into a FoxPro cursor. I think the main issue was with the length of string fields. Foxpro wants to work with a fixed length string so I had to extract some metadata information from SQL Server to get the defined field size. Just wondering is anyone has come up with an easier way to do this.