Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Any side effects in allowing NULL?
Message
De
30/03/2012 15:14:39
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
30/03/2012 15:03:29
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01539772
Message ID:
01539867
Vues:
44
>>>In some cases null is a must. Consider a lab result, where null means "was not done", and zero means "done, none found".
>
>I see the theorectical basis for it Dragan, but usually, I'd reply on a positive indicator in another column to tell me whether or not a lab test had been done, or perhaps there might be no row in the table at all if it hadn't been done.
>To my pedestrian brain It's like saying that a NULL date of birth in a kid's record means that the kid was never born.
>If he was never born then there's no kid!

Or the guy's birth records burned with the church when Napoleon invaded the area, and he's too old remember? There were such cases. A null simply means "no datum" (a singular of data).

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform