Used to indicate an uninitialized variable value. A variable value is uninitialized
when it is first created and no value is assigned to it, or when a variable value is
explicitly set to empty.
Example:Dim x 'the variable x is uninitialized!x="ff"
'the variable x is NOT uninitialized anymorex=Empty 'the variable x
Note: This is not the same as Null!
Used to test if a variable is uninitialized.
Example: If (IsEmpty(x)) 'is x uninitialized?
Example: Set myObject=Nothing
Example: If (myObject Is Nothing)
'is it unset?
Note: If you compare a value to Nothing, you will not get the right result!
Example: If (myObject = Nothing) 'always false
One way to think of Null is
that you has explicitly set the value to "invalid", unlike Empty where the
value is "not set".
Note: This is not the same as Empty or Nothing!
Example: x=Null 'x contains no valid data
Example: if (IsNull(x)) 'is x
Your Query was successfully sent!