I have a function in VFP that goes like this:

select padr(field,30) as field1,primarykey,space(20) as placeholder ;
from mytable into cursor _temp

cursortoxml([_temp],[lcXML])
return lcXML

.NET takes this XML string and creates a dataset. However, this:

cursortoxml([_temp],[lcXML],1,4)
return lcXML

which is supposed to be the default third paramter and the forth parameter = 4 which means preserve whitespaces. I need .net to preserve field1 to 30 characters but it doesn't. In fact, it doesn't even preserve fieldnames and the number of columns and seems to be totally confused by the XML that is returned by cursortoxml([_temp],[lcXML],1,4).

What is the correct syntax to preserve white space using cursortoxml() when passing the XML to .NET?