Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Empty dates being sent as 12/30/1899
Message
From
26/01/2001 19:03:16
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Empty dates being sent as 12/30/1899
Miscellaneous
Thread ID:
00469301
Message ID:
00469301
Views:
83
I am using a parameterized remote view from a VFP table. I used the MS VFP driver to set up the connection. When I initilize the parameters & do a requery on the view all the empty date fields come over as 12/30/1899. I tried to search the threads and only came up with one person who got 01/01/1899 from an SQL query and no listed solution.

I am confused as to what to do to correct this. (and where did they get such a wack date from)

Thanks in advance

Terry
It is impossible to make programs idiot proof. Idiots are too cleaver.

MCP( Tcp/Ip )
Next
Reply
Map
View

Click here to load this message in the networking platform