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 lcXMLwhich 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).