Another issue I have with SQLExpress is this:

A SQLSE table has a price field with a numeric(10,2) type.

When it comes to VFP through an SPT call it comes with the correct structure

(apparently)

But after transforming it with the cursortoxml function to produce a cXML

variable, the opposite function, xmltocursor fails in particularly that

field: the error message is that it is getting the incorrect data type

If I browse the cursor, it shows 23,50 ( not 23.50 as should be)

I solved it with the cast function in a select statement:

select cast(price as N(10,2)) as price from mycursor into ......

However, the price is 23.50 but I only get 23.00. No matter what I do, the

cents are discarded.

?????

Rafael Copquin