Re: Fwd: avoiding use of Nulls

2009-03-14 Thread Chris W
Arthur Fuller wrote: Exactly the point. Michael, NULL *is* information. It means "unknown" and that is in itself useful information. A common example: A new employee is hired but which department she will work in is unknown. So the data entry person enters all the known information and leaves t

Re: Fwd: avoiding use of Nulls

2009-03-14 Thread Johan De Meersman
It's a good thing, then, that we've got your experience to rely on. Woe is us, for not having any, and not seeing how obviously right you are. You're entitled to your opionion on NULLs, but kindly stop spamming *my* mailbox with it. I was aware of your dislike for them after the first mail. On S

Re: Fwd: avoiding use of Nulls

2009-03-14 Thread michael
Think! I'm not talking about how you application is designed. If your applications allows an employee to be entered without a position in the company, it is a bad design. If a manager at my company hired someone, and did not know what work the new-hire would be doing, well I'd really need to ask

Fwd: avoiding use of Nulls

2009-03-13 Thread Arthur Fuller
Exactly the point. Michael, NULL *is* information. It means "unknown" and that is in itself useful information. A common example: A new employee is hired but which department she will work in is unknown. So the data entry person enters all the known information and leaves the rest until it has be