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 vote331 views1 answer
Excel vba delete folder
VBA
0 vote351 views1 answer
Loop through each cell in dgv vbnet
VBA
1 vote341 views1 answer
Excel vba first row in range
VBA
2 votes333 views1 answer
Vba round number
VBA
1 vote335 views1 answer
Excel format cell as kilowatts
VBA
1 vote320 views1 answer
Vba delete array element
VBA
8 votes501 views1 answer
Excel vba make word from bytes
VBA
0 vote315 views1 answer
Check if program is running vbnet
VBA
0 vote339 views1 answer
How to use if condition in time vba
VBA
0 vote330 views1 answer
Excel vba automatic calculation
VBA