Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Any side effects in allowing NULL?
Message
 
 
À
30/03/2012 15:19:10
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01539772
Message ID:
01539902
Vues:
70
>>A date is one of the most common places for null.
>>
>>Rather than phony up a date and/or add another field to indicate that you have a valid date, leave it null to indicate it is not available.
>
>That works and probably half of the developers use that route. But, in the code, they then have to take care of it. Because, working with null causes errors, if use as is. Based on the backend, when I create a record, the proper empty date values will be put. VFP has a blank date value, SQL Server has this funny 1899 empty value meaning and such.

As Janis points out, nulls in and of themselves do not cause errors. Not handling them properly causes errors.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform