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 vote220 views1 answer
Vb streamreader
VBA
0 vote216 views1 answer
Vba find sub dictionary
VBA
0 vote225 views1 answer
Loop through lines in text file vb net
VBA
2 votes216 views2 answers
Vba code to remove duplicates from a column
VBA
3 votes227 views1 answer
Extract the nth word from a text string
VBA
-1 vote240 views1 answer
Vba sendkeys
VBA
8 votes365 views1 answer
Excel vba make a short integer from two bytes
VBA
0 vote221 views2 answers
Vb.net include quotes in string
VBA
0 vote220 views1 answer
Excel vba hide columns
VBA
-1 vote249 views1 answer
Text to speech vb.net
VBA