Hi,
Becouse some of my stored procedure parameters can be NULL, for every parameter with potential NULL value I have to do checking like this:
errorParams[3].Value = (e.InnerException==null)?(object)DBNull.Value:(object)e.InnerException;
When I do it like this ( it is a part of preparing values for insert ):
errorParams[3].Value = e.InnerException
no row is added. Is there any way to pass over that check : (e.InnerException==null)?(
and do it easier?
This the sample exception message for that issue:
{System.Data.SqlClient.SqlException: Procedure or Function 'sp_addError' expects parameter '@.InnerException', which was not supplied.
Thanks,
Pawe?
That depends on your Procedure declaration, you will have to allow a default parameter in orde to let it work.CREATE PROCEDURE sp_addError
(
@.InnerException VARCHAR(1000) = NULL --Which declares the default if no value is passed through
)
(...)
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de|||
Cool :) Big thanks!
Pawe?
|||Thank you very muchIt was solution of my Big problem
