Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Returning empty date to .NET
Message
 
To
01/03/2007 04:59:38
Alexandre Palma
Harms Software, Inc.
Alverca, Portugal
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
01199598
Message ID:
01200122
Views:
28
>Hi Dawa if you generate your xml like this CURSORTOXML("mycursor", "lcXML", 1, 0, 0, "1") you shouldn't get any prbs loading the data into .net dataset, what happens is that empty dates in vfp will become dbnull's in the .net datatable.

Alexandre,

Thanks for the reply.

I'm using CURSORTOXML("mycursor", "lcXML", 1, 0, 2, "1") in which case, nFlag=2 exports the empty fields with Open/Close tags. With nFlag=0, empty fields will not be exported and I should still see the column in the datatable, right? If so, my problem is solved. I'll try this out and let you know.
Dawa Tsering


"Do not let any unwholesome talk come out of your mouths,
but only what is helpful for building others up according to their needs,
that it may benefit those who listen."

- Ephesians 4:29-30 NIV

Dare to Question -- Care to Answer

Time is like water in a sponge, as long as you are willing you can always squeeze some.

--Lu Xun, Father of Modern Chinese Literature

Previous
Reply
Map
View

Click here to load this message in the networking platform