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 vote210 views1 answer
Excel vba calculate
VBA
0 vote230 views1 answer
Vba verticalalignment
VBA
5 votes238 views1 answer
Excel vba get user selected range
VBA
0 vote204 views1 answer
Hello world vb.net
VBA
0 vote209 views1 answer
Vlookup columns not next to each other
VBA
2 votes157 views1 answer
Excel vba pause
VBA
0 vote219 views1 answer
Excel vba Column Name to Column Number
VBA
0 vote225 views1 answer
.net dark title bar
VBA
0 vote210 views1 answer
Excel vba disable keyboard input
VBA
5 votes237 views1 answer
Excel vba tool to help with refactoring code
VBA