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 vote325 views1 answer
WGET FTP
VBA
0 vote307 views1 answer
Vba add month to date
VBA
0 vote323 views1 answer
Vbnet click on dgv cells
VBA
0 vote302 views1 answer
Refresh token em vb net
VBA
0 vote317 views1 answer
Excel vba join variant array
VBA
15 votes443 views2 answers
Xl vba dynamic string array
VBA
0 vote341 views1 answer
Vbnet convert charatcer to binary
VBA
1 vote315 views1 answer
Change the first item in a queue vb.net
VBA
0 vote309 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote352 views1 answer
Vbnet round to nearnest thousand
VBA