[AccessD] An Interesting question

LOL.  

Sure, I love a good debate...it's been to quiet around here anyways!

You're arguments are based on pure logic, which don't always hold true
when it comes to a computer system.  Ironic, eh?

Case in point, it is logical to assume that 0=0, but in some instances,
0<>0.  It can happen when you use a signed integer, you can end up with
-0.  In that case, even though the numeric value is 0. the sign bit is
turned on, so a computer will see 0<>-0.  Mathematically, there is no
such thing as a -0, but a computer can run into such an occurrence.

Now, null is a value representation just as 5, or 'hello', or 2/10/1999
is a value representation.  5 means nothing other then 5.  In a field of
'NumberOfUnits', then 5 represents the number of units.  Null is a field
value that represents a 'null value', which is a value that has not been
set.  It's a special condition.  An empty string is not null, it's an
empty string.  Null represents a value that has never been set before
(because as far as I know, you can't actually set a field to null once
it has had a value set...).

You're ball...

;)

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Sunday, March 29, 2009 6:35 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] An Interesting question

Correct, 
Black is not a colour,  but that's a different argument.
(and is white a color?)

Null is a condition (the absence of any value) not a value.

If Null were a value,  then 
If A is Null and B  is Null , A = B  would return True  

Try this:
 ? Null = Null,Not Null = Not Null,  1 = 1, Not 1 = Not 1 

You wanna debate? You sure you wanna debate?

:-)



On 29 Mar 2009 at 18:02, Drew Wutka wrote:

> So black isn't a color? ;)
> 
> The absence of a value is still a value... ;)
> 
> Is this going to be another great debate?
> 
> Drew
> 
The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.