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 vote211 views1 answer
Type excel.application is not defined vb
VBA
0 vote211 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
0 vote243 views1 answer
Add Formula to Shape Text in VBA
VBA
0 vote225 views1 answer
Vba min
VBA
8 votes302 views1 answer
Vba make integer
VBA
0 vote226 views1 answer
Pivot data source not accepting table named range vba
VBA
0 vote213 views1 answer
Do while not vb.net
VBA
0 vote236 views1 answer
Vba sort multiple columns
VBA
-1 vote253 views1 answer
How save excel through visual basic
VBA
0 vote224 views1 answer
Xlbycolumns is not declared
VBA