Hi Sergey.
I ended up using this technique because of another problem with ASP.NET removing the decimal portion of a number in my schema. My biz tier has a method with gives me the proper schema for a record, instead of the .NET modified version.
Thanks a ton for your help.
>You can try to pre-build cursor with date type for that field and run XMLTOCURSOR() with 8192 flag (use existing cursor).
>
>>>>I'm getting some XML passed into my VFP COM component from as ASP.NET page. The XML has dates in the form
>>>>
>>>>
>>>><xs:element name="date_in" type="xs:date" />
>>>><date_in>2002-08-01T00:00:00.0000000-07:00</date_in>
>>>>
>>>>
>>>>When I use XMLTOCURSOR(tcRecord,"cRecord",4) the date (datetime) field above is interpreted as {} instead of {^2002/08/01}. Anyone know how to correct this?
>>>
>>>The schema is specifying a "date" datatype, but the data in the
element is in the format for xsd:dateTime. Correct the schema to specify the dateTime datatype, and it should work fine.
>>
>>Since the datatime type is close to a date, it seems to me that XMLTOCURSOR should figure this out and truncate the data. Not sure if I should report this as a bug, or submit this to the wishlist.