S
Stephen
I have an Access Project with a list of contracts. When a user uses the
"new contract" form, they have the option to specify the employee name
(drop-down) who sold the contract. When then contract is saved, it passes
the contract informtion to a stored procedure to insert it into the
contracts table.
Cometimes, there is not an associated employee. In this case, I need to
pass NULL to the stored procedure. My syntax is:
conn.Execute ("spInsertClientMaintenanceContract @ClientID = " &
Me.ClientID & ", @StartDate = '" & Me.StartDate & "', @Expiration = '" &
Me.Expiration & "', @EmployeeID = " & Nz(Me.EmployeeID, NULL))
However, I cannot get the stored procedure to accept this null value.
How do I pass a NULL value to a stored procedure?
Help?
-Stephen
"new contract" form, they have the option to specify the employee name
(drop-down) who sold the contract. When then contract is saved, it passes
the contract informtion to a stored procedure to insert it into the
contracts table.
Cometimes, there is not an associated employee. In this case, I need to
pass NULL to the stored procedure. My syntax is:
conn.Execute ("spInsertClientMaintenanceContract @ClientID = " &
Me.ClientID & ", @StartDate = '" & Me.StartDate & "', @Expiration = '" &
Me.Expiration & "', @EmployeeID = " & Nz(Me.EmployeeID, NULL))
However, I cannot get the stored procedure to accept this null value.
How do I pass a NULL value to a stored procedure?
Help?
-Stephen