Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Any side effects in allowing NULL?
Message
 
 
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:
01539834
Views:
78
>>>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.

FWIW it wasn't me who posted that. IAC, I do see some value in nulls if you go back to the definition: the value is unknown. It is not the same thing as a value that evaluates to empty. Please don't take me the wrong way, I avoid them like the plague, but I wouldn't go as far as saying they have no conceivable benefit. You just have to be wery wery careful.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform