vba parameter adodb null value

The solution for “vba parameter adodb null value” can be found here. The following code will assist you in solving the problem.

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

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts