Vba parameter adodb null value

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: stackoverflow.com

Similar codes

-1 vote262 views1 answer
For i in range vba
VBA
0 vote288 views1 answer
Excel vba urlmon
VBA
0 vote274 views1 answer
Vba check 32 or 64 bit
VBA
0 vote295 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
25 votes372 views2 answers
Excel vba folder exist
VBA
0 vote260 views1 answer
Excel PasteSpecial Format:= can't find the argument
VBA
0 vote256 views2 answers
Excel vba prevent save
VBA
0 vote270 views1 answer
Excel protect cells with formulas
VBA
5 votes335 views1 answer
Vba low byte from INTEGER
VBA
0 vote272 views1 answer
Excel vba formatconditions positive
VBA