Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
FOX Oledb and empty date values
Message
De
12/11/2002 10:00:47
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Divers
Thread ID:
00721113
Message ID:
00721581
Vues:
10
>See Re: VFP OleDb Provider Update Thread #693808 Message #696262.
>
>>I am accessing some VFP data with OPENROWSET and ultimately returning the result to dataset in C#.
>>My empty VFP dates are set to 12/30/1899. Does anyone know where this default resides or if I can get empty dates to be returned as null?
>>
>>Thanks,

I assume the new OLE-DB provider will support the new EVL() function that is in VFP 8.0. If so, you can just wrap all your dates with it in your selects...

SELECT evl(DateField,null), field2, ...

BOb
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform