IsDBNull
Returns true if a value is a NULL data value that can be used by ADO.
Syntax
IsDBNull(Val)
Parameters
Val
Type: None
The value to test.
(return)
Type: Boolean
True if Val is a NULL data value that can be used by ADO, False otherwise.
Remarks
ADO requires nulls to be variants of type VT_NULL. By default, mrScriptBasic uses type VT_EMPTY when setting nulls, and therefore this function can be used to test if a NULL data value can be used by ADO.
Example
The following mrScriptBasic example tests a variable to see if its value is a NULL data value that can be used by ADO:
If MyVariable.IsDBNull() Then
... ' Can be used with ADO
End If
See also