Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Null Dates Defaulting to 12/30/1899
Message
From
04/03/1999 11:26:12
Paul De Niverville
Deniverville Econometric Research Ltd.
Victoria, British Columbia, Canada
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00193784
Message ID:
00194053
Views:
19
Hi Mike,

I had a similar problem when migrating fpw 2.6 tables into MS sql server.

I had to write some SQL code to change the incorrect dates in the ms sql server tables uploaded from fpw 2.6. I also had to change my data entry screens that new records did not have the problem.

Let me know if you want the sql code and details on the data entry screens.

Paul


>I am using VFP 5.0 and a Remote View with this particular application.
>
>The problem is, when I use the view, a date of 12/30/1899 appears in every field with a null or empty date.
>
>Has anybody seen this before? Any way to get around this?
Previous
Reply
Map
View

Click here to load this message in the networking platform