Hi Cetin,

OK, this way even the variant fields are brought in correctly, but on some recordsets I'm getting an error saying...

Program Error
XML Parse error: XML document must have a top level element.
Line 0, Position 0. (null)

...I haven't been able to figure out what's different about these recordsets, but it is very promising that it is handling variants with aplumb.


>>What's the best way known to transform a recordset into a cursor? Say you've got an ADO recordset that is already filled with data and you want to create a Visual FoxPro cursor from that recordset? I'm not looking to execute a SelectCmd on a CursorAdapter by issuing a CursorFill, as I already have the filled recordset object. One way I've found is using the r2dbf.prg that Microsoft released... http://www.kbalertz.com/192692/Converting.Recordset.Cursor.aspx
>>
>>I guess I'm looking for a slicker way to do this in VFP 9. I'm not sure if there is one, but if there is I'm sure someone on this list will have the answer. Thanks in advance.
>
>

>xDOM = NEWOBJECT('MSXML.DOMDocument')
>oRS.Save(xdom, 1)
>XMLTOCURSOR(xdom.xml, "MyCursorName", 1028)
>

>PS: Wouldn't work with all type of ADO recordsets - they don't work by any means anyway.
>Cetin