Thanks for the reply Fabio.

In digging into the problem some more, I discovered that in order to make a grid control (not VFPs) recognize an ADO recordset from ADOXML, I had to modify the CURSORTOADOXML() class. In particular, I had to change Rick's code as follows:

...
CASE lcType = "N"
...
s:datatype dt:type='r4'
...

The original code had dt:type='number' and for some reason, this caused the values of the column to appear as all zeros (0) even though the actual values are all non-zero!

I don't really know why, but, type=r4 did the trick.

Mike.


>Hi Mike,
>
>wwXML's CURSORTOADOXML() is supposed to generate an XML equivalent to the one ADO generates. The fields of type "i8" are created for Currency fields, so you have to guarantee that your cursor has a field of type "Currency" in order to it be mapped as type "i8" in the resulting XML.
>
>HTH.