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 vote168 views1 answer
How to self delete a vbscript file
VBA
0 vote196 views2 answers
Excel vba number format file size
VBA
1 vote192 views1 answer
Excel date to unix timestamp
VBA
0 vote177 views1 answer
Vba like with wildcard
VBA
0 vote231 views1 answer
Vba excel parser xml
VBA
3 votes197 views1 answer
Vba post request json
VBA
0 vote245 views1 answer
Excel vba add reference programmatically
VBA
0 vote196 views2 answers
Excel vba protect cells with formula
VBA
3 votes187 views1 answer
Vba make long from two shorts
VBA
0 vote203 views1 answer
VBA Sort RossetaCode
VBA