PRB: Remote View Displays Empty Date Fields with 12/30/1899
Article ID: 157424
Article Last Modified on 3/14/2005
APPLIES TO
- Microsoft Visual FoxPro 3.0 Standard Edition
- Microsoft Visual FoxPro 3.0b Standard Edition
- Microsoft Visual FoxPro 5.0 Standard Edition
- Microsoft Visual FoxPro 6.0 Professional Edition
- Microsoft Data Access Components 2.5
This article was previously published under Q157424
SYMPTOMS
If a Remote view accesses a table with an empty date field, then that field
is displayed with a value of "12/30/1899."
CAUSE
The ODBC driver has to return a value since it does not have a concept of
"empty" data. So, a default constant is a better choice than NULL in this
case. The date 12/30/1899 is the default value used in OLE and Microsoft
Access.
STATUS
This behavior is by design.
Additional query words: kbdse VFoxWin
Keywords: kbprb KB157424