Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Empty date fields
Message
De
16/02/2006 13:21:17
 
Information générale
Forum:
ASP.NET
Catégorie:
Web Services
Versions des environnements
Environment:
VB 8.0
Database:
Visual FoxPro
Divers
Thread ID:
01096812
Message ID:
01096821
Vues:
12
If you were using a .NET WebService instead of a VFP WebService, I'd say to make the date columns = DBNull.Value, but that obviously won't work in a VFP WebService. So, your only choice really is to populate empty dates with a value, I think the VFP preferred value is 12-31-1899 (don't quote me on that). I know it's different than the one you use for SQL Server (which is 1-1-1900).

~~Bonnie



>What is the preferred method to send empty date values from VFP to a .Net datatable. The .Net app is calling a VFP web service. When I execute the Dataset.ReadXml using XmlReadMode.ReadSchema it throws an exception when it encouters an empty date field.
>
>I'm guessing populate the empty date values from VFP prior to returning the xml data.
>
>Thanks,
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform