Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Empty date field returns 12/30/1899 with dsnless connection
Message
From
23/05/2002 16:23:35
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Empty date field returns 12/30/1899 with dsnless connection
Miscellaneous
Thread ID:
00660756
Message ID:
00660756
Views:
41
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
Map
View

Click here to load this message in the networking platform