Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ODBC Converts Fox 2.6 Empty Date to 12/30/1899
Message
 
 
À
14/09/2001 10:09:09
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00556439
Message ID:
00556505
Vues:
14
This message has been marked as the solution to the initial question of the thread.
See Thread #540115 Message #540476 for explanation.

>When using Microsoft ODBC Visual FoxPro Driver 6.01.8629.01 which is file vfpodbc.dll dated 05/08/01, to convert empty date in a Foxpro 2.6 dbf to an ODBC directory dbf, -- in the newly created ODBC dbf file , the empty date is filled with 12/30/1899.
>
>The current foxpro 2.6 files have " / / " in empty date fields which are data type of DATE. In my research on the web ..others have run into this same problem as ODBC driver does not read the content of " / / " as NULL and uses a default value of 12/30/1899.
>
>Any help in resolving this NULL date problem would be appreciated.
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform