Question : vba parameter adodb null value
Answered by : vastemonde
Dim cmd As New ADODB.Command
Dim p1 As ADODB.Parameter
' use Null as value
set p1 = cmd.CreateParameter("param_name", adVarChar, adParamInput, 50, Null)
p1.Attributes = adParamNullable
cmd.Parameters.Append p1
Source : https://stackoverflow.com/questions/1159796/vbscript-passing-a-parameter-with-a-null-value-to-a-stored-procedure | Last Update : Fri, 14 May 21