Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement