That's the way ODBC driver works. See
Crystal Reports 8.0 and vfp6 empty dates 12/30/1899 Thread #
540115 Message #
540476 for explanation.
>lcConnStr="DRIVER={Microsoft Visual FoxPro Driver};" + ;
>"SourceDB=c:\data\myData.dbc;SourceType=DBC;UID=;PWD=;"
>
>lnHandle=SQLSTRINGCONNECT(lcConnStr)
>IF lnHandle>0
> lSuccess=SQLEXEC(lnHandle,"SELECT * FROM myTable ORDER BY RefNo","cMyTable")
>ENDIF
>SELECT cMyTable
>BROWSE
>
>myTable is in myData database, and it has date fields.
>Empty date fields returns with 12/30/1899 date instead of empty.
>Does anybody knows why, or what am I doing wrong? Thank you all!
--sb--