General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only