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 vote173 views1 answer
Excel vba disable alerts
VBA
1 vote174 views1 answer
Vba delete file
VBA
0 vote173 views1 answer
Excel vba disable keyboard input
VBA
0 vote203 views1 answer
Vba vbcrlf chr
VBA
0 vote183 views2 answers
Vba remove line breaks
VBA
2 votes168 views1 answer
Vba split string
VBA
0 vote180 views1 answer
Excel vba automatic calculation
VBA
1 vote177 views1 answer
Vba date to unix timestamp
VBA
0 vote185 views1 answer
Vba keep command window open
VBA
0 vote184 views1 answer
Vba sort multiple columns
VBA