DBNull
Returns a NULL data value for use with ADO.
Syntax
DBNull()
Parameter
(return)
Type: None
Variant of type VT_NULL, containing a NULL data value.
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 must be used when setting nulls for use with ADO.
Example
The following mrScriptBasic example sets a variable to a null value that can be used with ADO:
Dim MyADOVariable
MyADOVariable = DBNull()
See also