Re: Examples of SQL anomalies?
From: paul c <toledobysea_at_ac.ooyah>
Date: Wed, 02 Jul 2008 15:25:08 GMT
Message-ID: <o5Nak.46675$kx.28611_at_pd7urf3no>
>
> No it isn't. I pay my bills ahead as much as possible -- an old habit
> from years of consulting work and irregular income. A zero bill simply
> means that my advance payments have been used up and my bill is paid
> this month. A NULL means the bill has not arrived yet, so I had
> better be ready to take action. Big differences in how I account for
> my expenses.
>
>
Date: Wed, 02 Jul 2008 15:25:08 GMT
Message-ID: <o5Nak.46675$kx.28611_at_pd7urf3no>
>>> If one expects a bill and the total is $0.00, that's just as useful to alert one that the bill has not yet arrived as a NULL would be. <<
>
> No it isn't. I pay my bills ahead as much as possible -- an old habit
> from years of consulting work and irregular income. A zero bill simply
> means that my advance payments have been used up and my bill is paid
> this month. A NULL means the bill has not arrived yet, so I had
> better be ready to take action. Big differences in how I account for
> my expenses.
>
>
Once again you are introducing confusion, in this case muddying the waters with unstated design questions, confusing a system that is designed to anticipate suppliers and bills with one that isn't. The fact that such misconnections is tolerated by so many is just a reflection of the rampant illiteracy in the western world today. Those people who can't position an English sentence relative to the task at hand are no different from the janitor I knew who wanted the computer to pick tommorow's track winners for him, they are basically incompetent for the task. Received on Wed Jul 02 2008 - 17:25:08 CEST