Surounding the date with single quotes helped me. There was a problem with the implicit conversion, apparrenty. :) Not sure if this can help you, but I wanted top throw it out there. If the datetime was blank you get the complimentary "1/1/1900 12:00 AM" in the table.
>From my a VFP7 COM component, I have passed an XML string created from a cursor with
>= CURSORTOXML("cResult","lcXMLResult",1,0,0,"1")
>
>If a date field in the cursor is blank, I get an error when I load the XML into a dataset using ReadXML in my asp.net page. Code is:
>
>lcXML = oClinserv.GetRecord(lnParentID);
>loStream = new StringReader(lcXML);
>loXmlTextReader = new XmlTextReader(loStream);
>dsClinserv.ReadXml(loXmlTextReader,XmlReadMode.ReadSchema);
>
>
>Error message is "String was not recognized as a valid DateTime." How can I prevent this error from happening and allow the XML string to be read into the dataset?
~Joe Johnston USA
"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams