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

1 vote170 views2 answers
Vba string length
VBA
0 vote166 views1 answer
Selecttoken em vbnet e json
VBA
0 vote171 views2 answers
Vba remove line breaks
VBA
0 vote164 views1 answer
Excel vba existence of a file
VBA
1 vote158 views2 answers
Vba function return array
VBA
0 vote171 views1 answer
Vba remove last vbcrlf
VBA
0 vote162 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
3 votes175 views1 answer
Vba post request json
VBA
0 vote164 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote172 views1 answer
Vba integer to double
VBA