Vba parameter adodb null value

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 vote257 views1 answer
Winforms dark title bar
VBA
0 vote215 views1 answer
Sort dictionary by key vba
VBA
0 vote225 views1 answer
Vbs run with cscript
VBA
0 vote203 views1 answer
Excel vba disable copy paste
VBA
0 vote207 views1 answer
Excel vba StartUpPosition
VBA
1 vote202 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote219 views1 answer
Dynamically change drop down list visual basic
VBA
0 vote202 views1 answer
Send webhook vbscript
VBA
0 vote238 views1 answer
Vbnet check if string is only letters
VBA
3 votes232 views1 answer
Excel insert blank row for value change in column
VBA