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 vote345 views1 answer
Excel vba address not absolute
VBA
1 vote356 views1 answer
Vba date to unix timestamp
VBA
0 vote324 views1 answer
Vb.net round to 2 decimal places
VBA
1 vote369 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
0 vote351 views1 answer
Vba type
VBA
0 vote349 views1 answer
Change whcih control a user has selected vb
VBA
0 vote371 views1 answer
Vba excel do not recalculate before save
VBA
0 vote358 views1 answer
WGET FTP
VBA
0 vote362 views1 answer
Weekday vba
VBA
0 vote324 views1 answer
Add Formula to Shape Text in VBA
VBA