camper12
asked on
Pass null to stored procedure
Hi,
I am trying to pass null to a parameter in stored procedure through vba. I am using the following:
If Sheets("f").Range("G3").Va lue = " " Then
rsCommand.parameters.Appen d rsCommand.CreateParameter( LB", adInteger, adParamInput, , Null)
Else
rsCommand.parameters.Appen d rsCommand.CreateParameter( "LB", adInteger, adParamInput, , Sheets("f").Range("G3").Va lue)
It is going to the if statement but in the watchlist it is not assigning NULL to LB but it is showing empty.
Thanks
I am trying to pass null to a parameter in stored procedure through vba. I am using the following:
If Sheets("f").Range("G3").Va
rsCommand.parameters.Appen
Else
rsCommand.parameters.Appen
It is going to the if statement but in the watchlist it is not assigning NULL to LB but it is showing empty.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
rsCommand.parameters.Appen