Vba createparameter null

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 vote188 views1 answer
Excel vba StartUpPosition
VBA
0 vote160 views1 answer
Excel vba concatenate range
VBA
8 votes190 views1 answer
Excel vba make integer
VBA
0 vote195 views1 answer
Selecttoken em vbnet e json
VBA
0 vote190 views1 answer
Nested if else in vb.net
VBA
1 vote193 views1 answer
Extract the second word in a text in excel
VBA
0 vote185 views2 answers
Open url from vba
VBA
0 vote190 views1 answer
Do while not vb.net
VBA
0 vote195 views1 answer
Excel vba urlmon
VBA
1 vote208 views1 answer
Vba format string as cash
VBA