I am passing in a set of parameters into a stored procedure. There are two flags in the list of parameters that I am passing in. I am defaulting the value to 0 (zero) on one parameter and 1 (zero) on another parameter. The sqlType is BIT.
Here’s the problem, the stored procedure isn’t recognizing the value and is always seeing 0. I have logged the parameter being passed in and see 0 (zero).
Is there a know problem with web methods and interpreting BIT vaues into a stored procedure.