>It turns out it doesn't like empty date/time fields. Setting them to null instead makes everything work. I guess there is a certain logic to it, although I would have expected the XMLAdapter to handle this.<

Oh, that figures ... I should have tried it without any data in the date field. But still, I'd call that a bug with the XMLAdapter.

~~Bonnie


>>Paul,
>>
>>In Tim's reply, he mentions that it must be utf8 encoded and that you need to set
>>
>>loXMLAdapter.UTF8Encoded = .t.
>>
>>What's interesting, is that I tried using the XMLAdapter with a few different tables *without* setting the UTF8 encoding and it worked just fine. My tables had char, logical, int, decimal ... even some memos and dates. All worked fine. So, I'm curious as to what kind of data causes the format errors. Anything peculiar in the table you're using?
>>
>
>It turns out it doesn't like empty date/time fields. Setting them to null instead makes everything work. I guess there is a certain logic to it, although I would have expected the XMLAdapter to handle this.