Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FOX Oledb and empty date values
Message
From
12/11/2002 10:00:47
 
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
00721113
Message ID:
00721581
Views:
9
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform