Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Any side effects in allowing NULL?
Message
From
30/03/2012 14:34:21
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
 
To
30/03/2012 11:19:33
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01539772
Message ID:
01539856
Views:
81
>>>In order to eliminate this issue I am thinking of always specifying/allowing NULL for every column of the empty cursor. Just in case. Will it slow down the processing of this cursor? The cursor usually is not very big, maybe up to 2000 records. What do you think?
>
>Other than allowing for sloppy programming, there is no conceivable benefit in allowing NULL and there are huge negatives.

In some cases null is a must. Consider a lab result, where null means "was not done", and zero means "done, none found".

Personally, I don't like nulls. They make our lives unpleasant at times. But when I really need them, I'm grateful they were introduced, and that Fox has the tools to handle them.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform