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

0 vote333 views1 answer
Vbnet click on dgv cells
VBA
0 vote291 views1 answer
How to self delete a vbscript file
VBA
0 vote339 views2 answers
Excel vba copy paste after last row
VBA
0 vote286 views1 answer
Vba set vs dim
VBA
0 vote330 views1 answer
Replace spaces with underscores vbnet
VBA
1 vote314 views1 answer
Vbscript convert ascii code to character
VBA
0 vote361 views1 answer
Excel vba first column in range
VBA
0 vote348 views1 answer
Columns dont autoresize on program start vb.net
VBA
0 vote319 views1 answer
Excel vba current folder
VBA
0 vote346 views1 answer
Date as number vb
VBA