Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ODBC -- convert empty date into {30/12/1899}..
Message
De
21/01/2003 03:01:37
 
 
À
20/01/2003 04:36:34
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00743388
Message ID:
00743666
Vues:
10
>>Hi,
>>
>>I am using the ODBC (USER DSN ) , it automatically convert the empty date into {30/12/1899}. Please you have the solution of this problem?
>>
>>thanks,
>>
>>Mobeen.
>
>Mobeen,
>For ODBC there is no empty date. Dates are calculated as numbers where integer part holds the days as offsett from {30/12/1899} and decimal part keeps the time as fractions of the day. An empty value defaults to 0 and it corresponds to base date {30/12/1899}.
>You can't have an empty date but a null. In your backend set date field to accept null.
>Cetin

Cetin,
Thank a lot!!!
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform