Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Null date fields in an SQL Table
Message
De
21/08/2002 22:24:30
 
 
À
21/08/2002 13:46:21
Stephen Hunt
Admit Computer Services Inc.
Farmingdale, New York, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00691903
Message ID:
00692307
Vues:
31
PMFJI, When you browse the view does the date field show NULL, Blank date or {01/01/1990}?

If it is showing the NULLS or an empty value, you may find that the date input mask is your problem. Just a SWAG, but try removing the input mask from the control that displays the date. The input mask may be changing the NULL to a blank date as you scroll through the view with a blank date being sent back to SQL Server. In ODBC for SQL Server, blank dates translate to 01/01/1990, In VFP database, they translate to 12/30/1899.

HTH
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform