Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Null Dates Defaulting to 12/30/1899
Message
From
03/03/1999 18:39:06
Bob Lucas
The WordWare Agency
Alberta, Canada
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00193784
Message ID:
00193837
Views:
17
>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?

It could be that somewhere in your code or framework you have NULLDISPLAY displaying that date. What is the remote database? VFP should display .null. in the field if the value is a null. Some databases will not store an empty date (VFP {}) and will store a default value like that above instead. If you update the view you should store a valid date or an explicit NULL in the datefield and not {}.
Previous
Reply
Map
View

Click here to load this message in the networking platform