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 is uninitialized
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 invalid?
Your Query was successfully sent!