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 vote385 views1 answer
Vba add shape oval
VBA
0 vote349 views1 answer
Excel vba show developer tab
VBA
0 vote378 views1 answer
Vbnet find highest value in chart
VBA
1 vote343 views1 answer
Excel vba last row of range
VBA
0 vote346 views1 answer
Refresh token em vb net
VBA
0 vote399 views1 answer
Excel vba convert cells address
VBA
8 votes482 views1 answer
Excel vba make word
VBA
0 vote390 views1 answer
Vba parameter adodb null value
VBA
0 vote355 views1 answer
Excel vba address not absolute
VBA
0 vote358 views2 answers
Vba remove line breaks
VBA