Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using XMLAdapter to create a dataset
Message
 
To
04/01/2005 10:51:09
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro and .NET
Environment versions
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00973971
Message ID:
00974239
Views:
22
>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.
-Paul

RCS Solutions, Inc.
Blog
Twitter
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform