Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Null Dates Defaulting to 12/30/1899
Message
De
03/03/1999 18:39:06
Bob Lucas
The WordWare Agency
Alberta, Canada
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00193784
Message ID:
00193837
Vues:
18
>I am using VFP 5.0 and a Remote View with this particular application.
>
>The problem is, when I use the view, a date of 12/30/1899 appears in every field with a null or empty date.
>
>Has anybody seen this before? Any way to get around this?

It could be that somewhere in your code or framework you have NULLDISPLAY displaying that date. What is the remote database? VFP should display .null. in the field if the value is a null. Some databases will not store an empty date (VFP {}) and will store a default value like that above instead. If you update the view you should store a valid date or an explicit NULL in the datefield and not {}.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform