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 votes350 views1 answer
Excel vba determine number of elements in a 2D array
VBA
3 votes286 views1 answer
Excel vba change format of cell
VBA
0 vote273 views1 answer
Discern between file and folder given path vb.net
VBA
0 vote272 views1 answer
Vba string start with
VBA
0 vote296 views1 answer
Excel vba unlock sheet without password
VBA
0 vote298 views1 answer
Vba range clear formatting
VBA
0 vote301 views1 answer
How to mount floppy disks in vb.net
VBA
0 vote291 views1 answer
Excel vba ternary
VBA
1 vote260 views1 answer
Vba listindex select multiple items vba
VBA
0 vote311 views1 answer
Como ler subitem de um array em json usando vbnet
VBA