Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Returning empty date to .NET
Message
De
01/03/2007 04:59:38
Alexandre Palma
Harms Software, Inc.
Alverca, Portugal
 
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Divers
Thread ID:
01199598
Message ID:
01199897
Vues:
34
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.

>Hi all,
>
>I've got a web app which calls a method of a VFP component, which returns an Xml string. This Xml string is read into a dataset. There is a date field in this Xml. A problem occurs if the date field is blank when the Xml is being read into the dataset. The error message says: "The string '' is not a valid AllXsd value". So from the VFP component I'd like to pass the .NET minimum date if that field is empty. However while .NET minimum date is 1/1/0001 12:00:00 AM , VFP would only allow me set the date to as early as datetime(100,1,1,0,0,0).
>
>What I'm doing now is to pass VFP's date(100,1,1,0,0,0), then check it in the web app and convert it to .NET's minimum date time.
>
>Is there a simpler way to handle this?
Alexandre Palma
Senior Application Architect
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform