Microsoft KB Archive/157424

= 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.



Steps to Reproduce Behavior
 Using the 32-Bit ODBC Driver Manager create a datasource to access the Labels.dbf table in the Visual FoxPro 3.0, 5.0 or 6.0 directory. You want to use the Visual FoxPro Tables (Microsoft Visual FoxPro Driver) and select the Free Table Directory as the Database Type.  Run Visual FoxPro and Browse Labels.dbf using the following: SET CENTURY ON     USE HOME+"Labels.dbf" BROWSE  Look at the Update field and note that it is empty for all the records in the table. Close the Labels.dbf table. Open a database or create a new one, then create a remote view based on the Labels.dbf table using the datasource created earlier. In the Fields tab, click the "Add All" button to select all fields for output. Browse the view.</li></ol>

Look at the Updated field and notice that all the records contain a value of "12/30/1899."

NOTE: This behavior exists with any type of remote datasource that allows the date fields to be empty.

Additional query words: kbdse VFoxWin

Keywords: kbprb KB157424

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.