MS SQL Stored Procedures , Visual Studio 2005 , "Input values cannot
am 07.04.2008 05:03:17 von AccessedA few people in the DOT NET world have noticed that when stepping
through SQL stored procedures using Visual Studio 2005, when
debugging, an error can occur.
This bug occurs if you try to call a stored procedure that uses a BIT
type of Parameter.
The error message "Input values cannot be converted" occurs , as you
are debugging .
This can be cured if you change the Parameter type to TINYINT.
ALTER PROCEDURE [dbo].[usp_CashBookBulkProcess]
(
@InVRevID INTEGER,
@InVIsNewSplit BIT, -- THIS CAUSES ERROR IN VISUAL STUDIO 2005,
CHANGE IT TO A TINYINT)
@InVdtSettlement DATETIME,
@InVLFID INTEGER,
@InVLoanID INTEGER,
@InVStatus TINYINT output,
@OutVCallReturnMessage VARCHAR(250) output
)
as
....etc
It will work ok in Enterprise manager though, without any trouble.
I have posted this message only for reference by others who may
encounter the problem, as I could not find another posting on the
topic.