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

8 votes266 views1 answer
Excel vba make word from bytes
VBA
0 vote151 views1 answer
Create new worksheet excel visual basic
VBA
0 vote125 views1 answer
Vba string start with
VBA
0 vote125 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
22 votes249 views1 answer
Xlvba check for folder
VBA
0 vote117 views1 answer
Excel vba disable screen update
VBA
0 vote135 views1 answer
Vba exit while
VBA
0 vote125 views1 answer
How to use if condition in time vba
VBA
0 vote125 views1 answer
Vba compare strings
VBA
2 votes121 views1 answer
Excel vba extract file name
VBA