Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ADO problem date and time fields
Message
De
02/05/2000 13:43:28
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00364980
Message ID:
00365214
Vues:
22
>When you use the OLE-DB Provider for ODBC, I beleive empty dates are returned as 12/30/1899 12:00:00 AM. If you have a blank date in a VFP Cursor and you query that value from the ADO Recordset, this is the date you get.
>
Do you know why they would choose this date for an (ODBC return) "empty" date? MS seems to have little rhyme or reason on this, e.g. the "empty" date in Outlook being 1/1/4501.
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform