Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Empty date field returns 12/30/1899 with dsnless connection
Message
De
23/05/2002 16:23:35
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Empty date field returns 12/30/1899 with dsnless connection
Divers
Thread ID:
00660756
Message ID:
00660756
Vues:
40
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!
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform