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 vote269 views1 answer
Show unix time in vba
VBA
0 vote261 views1 answer
Change form background image vb
VBA
0 vote296 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
1 vote281 views1 answer
Excel vba array remove first
VBA
0 vote294 views1 answer
Excel vba protect sheet
VBA
1 vote265 views1 answer
If inputbox cancel vba
VBA
22 votes384 views1 answer
Excel vba check if directory exists
VBA
-1 vote254 views2 answers
How close excel through visual basic
VBA
0 vote265 views1 answer
Vb net dgv doesn't keep currency format
VBA
0 vote277 views1 answer
Vba first cell in range
VBA