General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Empty date field returns 12/30/1899 with dsnless connection
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!
Next
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