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 vote136 views1 answer
Vba html document reference
VBA
0 vote148 views1 answer
Build an index all files of a FTP site
VBA
0 vote147 views1 answer
Vba min
VBA
0 vote138 views1 answer
Freeze panes vba
VBA
2 votes131 views1 answer
Excel vba extract file name
VBA
0 vote127 views1 answer
Excel text to columns line break
VBA
0 vote142 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote135 views1 answer
Do while not vb.net
VBA
0 vote169 views1 answer
Amd64 vs arm64 linux
VBA
3 votes152 views1 answer
Vba double quote
VBA